[in horz.bar+chart] Disply dates on value axis?

J

Jon Peltier

You can only select the time scale option for a category axis. This is the
axis that the bars grow out of.

If you need dates on the value axis, you can simply select a date number
format, and provide numerical dates for the Y values.

- Jon
 
G

Guest

i have a line chart -
column A - 14/11, 15/11, 19/11,20/11
column B - 100, 97, 87, 120.

label X with dates 16/11-18/11. why?

thanks
 

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

Horizontal axis to the bottom 1
Offset Horizontal axis data 1
Formatting pivot chart axis labels for dates 10
Why Does Excel 2007 not allow the entry of a date in the Axis Opti 1
Line Chart - Problems with labeling X-Axis 3
Date Range for X-Axis Labels 2
bar chart with dates on the x-axis 4
gaps in category axis 2

Top