Send to a Friend
Displaying dates on a PC using excel 2010 to create charts and graphs?
Asked by Deniwrig (14)
October 15th, 2011
I am trying to create charts and graphs using excel 2101 on a PC. I want the charts to display only those dates for which I have data. The default is displaying all the dates between.
Example:
I have data for sept 3,5,9th I want to display data points on a line graph. The default is displaying sept,1,2,3,4,5,6,7,8,9 and placing the data correctly but including blank dates as well. This is making the graph far too long. I want to show only those dates where there is a data point. Does any one know how to change the settings to show only those dates you enter?
Using Fluther
or