| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| devide by 1000 | Excel Discussion (Misc queries) | |||
| Cell with numbers and names, need to devide them | Excel Discussion (Misc queries) | |||
| Why are graphs/charte created in XL 2003 missing in 2007? | Charts and Charting in Excel | |||
| devide by 0 error | Excel Worksheet Functions | |||
| Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
Linear Mode
