Y Axis

[Soltisolti]

Is it possible to have a Y axis like this?

4
3
2
1 goes back to one
8
7
6
5
4
3
2
1
0

Thanks solti

[Bryan Hessey]

Is it possible to have a Y axis like this?

4
3
2
1 goes back to one
8
7
6
5
4
3
2
1
0

Thanks solti

Hi,

the site http://www.andypope.info/charts/brokencolumn.htm shows a broken level chart, but I doubt that it can have the values reset to 1, was there a reason to reset this to 1?

---

[Soltisolti]

I am trying to combine two stock count charts, chart background is green, yellow and red

0 = green all items are above safety stock
1 - 8 = yellow number of items below safety stock limit

1 -4 = red number of items out of stock

I have got around it by not showing the Y axis and using text boxes, wondering if there is a better way?

Have attached a jpg

solti

[MrShorty]

I don't know if it's a "better" way, but you can create all kinds of "axes" using dummy series and Rob Bovey's XY Chart Labeler add-in. See http://www.peltiertech.com/Excel/Charts/axes.html for examples.

[Soltisolti]

MrShorty thanks some interesting stuff

[Ola@ExcelTips]

Is it possible to graph more than one series on the secondary Y-axis?
If Yes. How?

[MrShorty]

In the "Format" dialog for each series is an axis tab. Make sure that "secondary axis" is selected for all the series you want plotted on the secondary axis.