Extra Dates

[Greg]

XL 2007, This should be a very simple chart but I'm getting extra data
points (dates) which are not in the data. Dollars vertical, dates
horizontal. There are 23 actual data points but the chart shows 30. The
last date in the data is 6/15/2009 but the chart has 6/18, 6/20, 6/22 and
6/24.

How do I format the chart to get only actual data points and not these
others?

Greg

 

[Shane Devenshire]

Hi,

If your chart is using a date data type for the x axis it will set the range
of dates. if you want to just see your dates than you can change the axis
type - right-click the axis and choose Format Axis, on the Axis Options tab
under Axis Type choose Text axis and see if that helps.

 

[Greg]

Thank you that worked to fix the dates problem but it had the unintended
consequence of moving the Y axis $ labels from the left side to the right?
What’s with that?

Greg

 

[Greg]

Never mind, I formatted the Y axis to low (not left) and the labels moved
back to the left hand side. Who'da thunk it!