Home |
Search |
Today's Posts |
#11
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() -- thank you! Mavy "Andy Pope" wrote: I assume then the problem is alignment of the zero's on each axis. In which case see Jon Peltier's page http://peltiertech.com/Excel/Charts/AlignXon2Ys.html Cheers Andy osof wrote: Yes. I put the percentage in the 2nd axis. I tried doing it without the negative figures and it turns out ook sometimes but when I try to put in the negative figures it totally changed the chart instead of just adding a stacked column at the bottom. IT semms like negative figures for stacked columns doesnt' wanna work with the percentage line series. Sorry about my example... Here's more. Thanks for all the help! Liablities Net Book 1 Book 2 Gross 0.00% 0.00% 2004 ($28,000) $28,000 $47,000 $9,000 2003 (29,000) 40,000 45,000 10,000 2006 (30,000) 42,000 50,000 11,000 330.80% 252.80% -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combination charts: two variables in one series? | Charts and Charting in Excel | |||
Bar and line combination charts | Excel Discussion (Misc queries) | |||
Column-Line combination charts | Charts and Charting in Excel | |||
How lines in combination charts treat #N/A values | Charts and Charting in Excel | |||
combination charts - multiple columns | Charts and Charting in Excel |