Send to a Friend

Deniwrig's avatar

Displaying dates on a PC using excel 2010 to create charts and graphs?

Asked by Deniwrig (14points) 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

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.