ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   [in horz.bar+chart] Disply dates on value axis? (https://www.excelbanter.com/charts-charting-excel/106933-%5B-horz-bar-chart%5D-disply-dates-value-axis.html)

Boswell

[in horz.bar+chart] Disply dates on value axis?
 
Something about selcting - 'date option'.
But, where, how?
--
Boswell

Jon Peltier

[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




msouza

[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




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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com