Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 28
Default [in horz.bar+chart] Disply dates on value axis?

Something about selcting - 'date option'.
But, where, how?
--
Boswell
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default [in horz.bar+chart] Disply dates on value axis?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Boswell" wrote in message
...
Something about selcting - 'date option'.
But, where, how?
--
Boswell



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default [in horz.bar+chart] Disply dates on value axis?

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting dates on the Y axis without weekends JenTK2006 Charts and Charting in Excel 1 July 22nd 06 10:30 PM
Chart Dates on X Axis Bill Martin Excel Discussion (Misc queries) 0 February 14th 06 04:01 PM
Value (Y) axis crosses between dates Frager Charts and Charting in Excel 2 January 17th 06 11:13 PM
line graph-need to pick up dates as values for the x axis? mountainair Charts and Charting in Excel 2 November 23rd 05 09:02 PM
Formatting dates on x axis of chart...! saturnin02 Excel Discussion (Misc queries) 4 January 27th 05 08:55 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"