If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charte - how to devide the axes into 2 sones
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 |
#2
|
|||
|
|||
Charte - how to devide the axes into 2 sones
Excel 2007, PivotChart
Divide vertical axis into two ranges. http://www.mediafire.com/file/m3ujunm1zi2/10_23_09.xlsx |
#3
|
|||
|
|||
Charte - how to devide the axes into 2 sones
If I understood you correctly, see
Graphical display of numbers that differ by a magnitude http://www.tushar-mehta.com/excel/ch...ifferences.htm On Wed, 21 Oct 2009 00:22:01 -0700, Kathrine wrote: 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 Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
Thread Tools | |
Display Modes | |
|
|