X-Axis is missing a data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

misterno - 26 Feb 2007 18:53 GMT

I have this chart where x-axis is representing days from december 1, 2006
until April 8 2007. When I create a chart, the X-Axis shows dates weekly
which is every Friday. But since April 8 is not Friday it is now shown. How
can I tweak Excel to show April 8 on the X-Axis?
Thanks

Reply to this Message

Jon Peltier - 27 Feb 2007 05:02 GMT

Several options:

1. Adjust the major unit of the X axis so it isn't a nice interval like 7
days.
2. Add a data label to the point so you don't need an axis tick label.
3. Change from a time scale to a category axis, which shows each point, not
just the nicely spaced weekly ticks. Chart menu > Chart Options > Axes tab.

I think I prefer #2.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

>I have this chart where x-axis is representing days from december 1, 2006
> until April 8 2007. When I create a chart, the X-Axis shows dates weekly
> which is every Friday. But since April 8 is not Friday it is now shown.
> How
> can I tweak Excel to show April 8 on the X-Axis?
> Thanks

Reply to this Message