ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Formatting Chart Axis - Bar Graph (https://www.excelbanter.com/charts-charting-excel/123810-formatting-chart-axis-bar-graph.html)

JICDB

Formatting Chart Axis - Bar Graph
 
The solution to this problem is probably in formating somewhere but I can't
figure it out and there was only one mention of the same problem on this
board and no one answered it.

I am making a stacked bar graph to show an indicator 1-5. I set zero as the
min and 5 as the max. I have two series - one is the indicator (2) and the
other is for the "holder" the balance of 5-2 (3). This makes kindof a guage.

When I first create the chart, Excel puts it into percents. I want the axis
to say 0-5 but when I change it, something is still formatted in percents
because the axis labels I get are 0000011111. (or something like it).
Please help! I think I've just been working on this too long and need a
break. I'm sure its easy and will kick myself when I find out the solution.

Rob Hick

Formatting Chart Axis - Bar Graph
 
i can't quite work out what you mean from the post but you could
possibly try using a stacked bar chart rather than a percentage stacked
bar chart. If that still doesn't work, you could use a false axis.
There are numerous postings about how to do this, or see j-walk.com or
Tushar Mehta's site. Both are great.

Rob

On Dec 27, 5:04 pm, JICDB wrote:
The solution to this problem is probably in formating somewhere but I can't
figure it out and there was only one mention of the same problem on this
board and no one answered it.

I am making a stacked bar graph to show an indicator 1-5. I set zero as the
min and 5 as the max. I have two series - one is the indicator (2) and the
other is for the "holder" the balance of 5-2 (3). This makes kindof a guage.

When I first create the chart, Excel puts it into percents. I want the axis
to say 0-5 but when I change it, something is still formatted in percents
because the axis labels I get are 0000011111. (or something like it).
Please help! I think I've just been working on this too long and need a
break. I'm sure its easy and will kick myself when I find out the solution.



JICDB

Formatting Chart Axis - Bar Graph
 
Thanks! I'll try your suggestion and then if it doesn't work I'll check out
the web sites.

"Rob Hick" wrote:

i can't quite work out what you mean from the post but you could
possibly try using a stacked bar chart rather than a percentage stacked
bar chart. If that still doesn't work, you could use a false axis.
There are numerous postings about how to do this, or see j-walk.com or
Tushar Mehta's site. Both are great.

Rob

On Dec 27, 5:04 pm, JICDB wrote:
The solution to this problem is probably in formating somewhere but I can't
figure it out and there was only one mention of the same problem on this
board and no one answered it.

I am making a stacked bar graph to show an indicator 1-5. I set zero as the
min and 5 as the max. I have two series - one is the indicator (2) and the
other is for the "holder" the balance of 5-2 (3). This makes kindof a guage.

When I first create the chart, Excel puts it into percents. I want the axis
to say 0-5 but when I change it, something is still formatted in percents
because the axis labels I get are 0000011111. (or something like it).
Please help! I think I've just been working on this too long and need a
break. I'm sure its easy and will kick myself when I find out the solution.





All times are GMT +1. The time now is 10:36 PM.

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