ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Change base of bar chart (https://www.excelbanter.com/charts-charting-excel/168612-change-base-bar-chart.html)

[email protected]

Change base of bar chart
 
I have a bar chart. It's a standard little bar chart.

The bar chart's base starts at 0 zero. What if I wanted to change the
0 to some other number, like 100 so that values less than 100 would
fall below the baseline?

Is this doable?



Thanks!

Gleep

Jon Peltier

Change base of bar chart
 
I presume you want to change the minimum on the Y axis. Double click the
axis, and on the Scale tab, enter the changes you need.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
I have a bar chart. It's a standard little bar chart.

The bar chart's base starts at 0 zero. What if I wanted to change the
0 to some other number, like 100 so that values less than 100 would
fall below the baseline?

Is this doable?



Thanks!

Gleep





All times are GMT +1. The time now is 12:44 PM.

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