user defined scale on chart

  • Thread starter Thread starter forever_49ers
  • Start date Start date
F

forever_49ers

Hi,

is there a way to have a non continuous scala on a excel chart ?

I have a financial chart that shows expenses from 100.000 up t
14.000.000. Since the 100.000 is so small its hardly visible on th
chart (min : 0 / max: 16.000.000 )

I use major unit : 2.000.000 so the chart would display the axis scal
0 / 2Mil / 4 Mil / 6 Mil / 8 Mil / up to 16Mil.

Since most of my datas are around 2 - 4 Mil. the 14 Million reall
stand out on the chart are make the low numbers almost disappear.

Is there a way to define the scale that the chart would show on th
axis 0 / 2 / 4 / 6 Million and then the next line be 14 / 16 and ski
the 8 / 10 / 12 Million to make the smaller entries more visible whil
keeping the chart at the same size ?

hope I could explain understandable.

thanks

Steffe
 
Steffen -

There are a few ways to do this. First, you could use a logarithmic
scale. Unfortunately this is not readily comprehensible to many people,
particularly non-technical types. Second, you could use a secondary axis
for the outlying data. Unfortunately this is also not easy to
understand, particularly if you hurry through the chart's construction.
The third thing you can do is simulate a broken axis. This capability is
not native to Excel, but you can fake it. I show one method on my web site:

http://peltiertech.com/Excel/Charts/BrokenYAxis.html

I also have links to a couple other techniques.

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