|
|
#3
10-13-2024, 03:14 PM
|
||||
|
||||
Another 2 ways in the attached:
On Sheet1, an Autofilter has been applied to column J to keep only rows where the value is greater than 14 On Sheet2, the number 14 has been entered in cell L1. This number is used in the formulae in the cells in column K, to show the number in column J if it's greater than the value in cell L1 or #N/A if it's not. It's this column K which is plotted. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to create a report with a graph showing data from diferent updates/status data | MikelZU | Project | 1 | 04-30-2021 12:19 AM |
| Formula to deduct a figure the sum of two cells is equal to or greater than a certain valu | AlanBird | Excel | 3 | 11-25-2017 03:11 PM |
 Auto update excel graph range, ignore data when date reads 00-Month-00
|
SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
| Need help with excel formula greater than.. | bm868 | Excel | 2 | 01-02-2016 10:29 AM |
| How to create a column graph from row data in excel | jyfuller | Excel | 0 | 07-02-2013 05:07 AM |
Windows 10 
Office 2021
Threaded Mode