Number formatting in Chart

[smanjunath]

Hi,

I am in need of a number format code which will show the vertical axis labels as below


100

80

40

20

0

100 (actually -20)

80 (actually -40)

40 (actually -80)

20 (actually -100)

0 (actually -120)


I hope i made some sense...

 

[Hui]

Manjunath


I don't think this will be possible using the Chart Axis Format system for most chart types

It may be possible if you are using a Horizontal Bar Chart


The only other alternative would be to use Text Boxes located in the same location as the axis and referencing some cells on the worksheet where the text is setup

You can see an example here: https://www.dropbox.com/s/xyxsyot5me2hqsw/Actually%20Chart.xlsx


Will the scale always be 0 to 100 or can it take other values?


What type of chart are you using?

 

[smanjunath]

Hi, extremely sorry for late reply.


The scale is pretty much fixed. 0-100


it is a clustered vertical bar graph


the idea is to have two different graphs in one chart....so i made one with positive values and other with negative values so that they appear in the same chart. the problem was the lower graph starting to 'hang' from center line. i want both the graphs to start from botttom....

 

[Hui]

Can you use the secondary Y axis and have a different scale in it?

Select one of the series, Right Click, Format Series, Plot on Secondary Axis

 

[Montrey]

Try scaling your data series. so that ~20 is = ~100

 

[Guest]

 

[smanjunath]

@Hui, I did use secondary axis to start with, which works fine, but my 'end user' wants all axis labels one one side (left side) only.

[pre]

100
80
60
40
20
0
100
80
60
40
20
0

and not like 

100
80
60
40
20
0
............100
............ 80
............ 60
............ 40
.............20
............. 0

[/pre]

 

[smanjunath]

@ Montrey

sorry i could not get what u mean..