Hi,
I am trying to get data to plot in a chart which is taken from a Vlookup on the date, so only some of the dates have data beside them, others have #N/A (can change this to whatever I want).
My aim is to produce a Bar chart that only shows the dates that have any data - for example my graph I envisage as below:
5
4
3
2
1
02/03/15 04/03/15 15/03/15 16/03/15 31/03/15
currently I get every date of the month along the X axis due to my column having each date listed even if the value is zero, can anyone suggest a way to fix this without having to amend the source data?
Thanks
J
I am trying to get data to plot in a chart which is taken from a Vlookup on the date, so only some of the dates have data beside them, others have #N/A (can change this to whatever I want).
My aim is to produce a Bar chart that only shows the dates that have any data - for example my graph I envisage as below:
5
4
3
2
1
02/03/15 04/03/15 15/03/15 16/03/15 31/03/15
currently I get every date of the month along the X axis due to my column having each date listed even if the value is zero, can anyone suggest a way to fix this without having to amend the source data?
Thanks
J