ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Values on 'y' axis - columm chart type (https://www.excelbanter.com/charts-charting-excel/131699-values-y-axis-columm-chart-type.html)

Belcha

Values on 'y' axis - columm chart type
 
Hello,

I just open an spreadsheet with some graphs I did a few days ago and it
appears as if the values on the 'y' axis have been rounded up
(0,1,1,2,2,3,3,4,4,5....etc) instead of been in a scale (0, 0.5, 1, 1.5,
2.....etc). The source data for the graph has not changed.

I would appreciate it if someone could let me knwo why this has happened and
how can I change it back.

Thanks

David Biddulph

Values on 'y' axis - columm chart type
 
Format Axis/ Number/ Decimal places?
You could try changing from Number to General?
--
David Biddulph

"Belcha" wrote in message
...
Hello,

I just open an spreadsheet with some graphs I did a few days ago and it
appears as if the values on the 'y' axis have been rounded up
(0,1,1,2,2,3,3,4,4,5....etc) instead of been in a scale (0, 0.5, 1, 1.5,
2.....etc). The source data for the graph has not changed.

I would appreciate it if someone could let me knwo why this has happened
and
how can I change it back.

Thanks





All times are GMT +1. The time now is 07:15 AM.

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