Charte - how to devide the axes into 2 sones

  • Thread starter Thread starter Kathrine
  • Start date Start date
K

Kathrine

If I have a chart where one of the series has a really large amount, compared
to the rest of the chart , is it possible to cut the length of the chart
column down (on this one series only) so that the difference is not so big
between the colums.

THis is in Excel 2007. I know it is possible to make a secondary axes, but
how to make all the colums show....

Thanks in advance!

Kathrine
 
If I understood you correctly, see
Graphical display of numbers that differ by a magnitude
http://www.tushar-mehta.com/excel/charts/plot_magnitude_differences.htm


If I have a chart where one of the series has a really large amount, compared
to the rest of the chart , is it possible to cut the length of the chart
column down (on this one series only) so that the difference is not so big
between the colums.

THis is in Excel 2007. I know it is possible to make a secondary axes, but
how to make all the colums show....

Thanks in advance!

Kathrine
Click to expand...
Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
 
Back
Top