Good afternoon.
I have created a scrolling table which has data in the date order. Now I have linked a bar chart to the table to display the data in a simple visual way, the problem I have is the following.
The dates in the data are not consistent, for example I have,
10/08/10
11/08/10
14/08/10
15/08/10
Now as you can see the 12th and 13th are missing from my list, however the bar graph will display the 12th and 13th with no data, this really causes problems as I am using a double axis graph.
Do any of you Excel guru’s have any idea how to stop the chart from putting in dates that I don’t need.
Thanks in advance for your help!
I have created a scrolling table which has data in the date order. Now I have linked a bar chart to the table to display the data in a simple visual way, the problem I have is the following.
The dates in the data are not consistent, for example I have,
10/08/10
11/08/10
14/08/10
15/08/10
Now as you can see the 12th and 13th are missing from my list, however the bar graph will display the 12th and 13th with no data, this really causes problems as I am using a double axis graph.
Do any of you Excel guru’s have any idea how to stop the chart from putting in dates that I don’t need.
Thanks in advance for your help!
