Dates in Charts

  • Thread starter Thread starter Erika
  • Start date Start date
E

Erika

I have a chart that I have created based on data that lists dates and
amounts. The dates are not consecutive however when I create the chart it
shows all dates

March 1, March 2, March 3

Even though I did not enter March 2 at all. How do I stop it from doing that?
 
you cant. just like if you had numeric data 0, 3, 9, 15 and plotted it.
the numbers in between are still shown on the axis.

AGP
 
Change the axis type from Automatic or Time Scale (Date Scale in 2007) to
Category (Text in 2007). Pre 2007, right click the chart, choose Chart
Options, and on the Axes tab, change the selection. In 2007, select the
axis, press Ctrl+1 (numeral one) to format it, and in the dialog's first
tab, change the axis type.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 
Back
Top