Hello Excel users,
How would you create a chart that only plots certain criteria.
Example:
Column A
Jan 1
Jan 2
Jan 3
Column B
Sales area 1
0
0
1
Column C
Sales area 2
3
5
8
Column D
Sales area 3
4
2
9
I'd like to plot on a line chart only the columns that have a daily average of 'x'. I.e. in this example greater than 1 - so area 2 and area 3.
How would you go about this?