X-Axis is missing a data

G

Guest

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Primary X axis to Secondary X axis 1
swapping axis' 5
Excel 2007: X-axis labeling 1
Line Chart - Problems with labeling X-Axis 3
Time(X) Axis Scale in 97 5
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1

Top