| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination charts
Question, I want to make a stacked-column chart with horizontal lines and I
can't seem to do it no matter what I do like even change the series. PLease help! -- thank you! Mavy |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
Hi,
Is the stacked column the 3d variety? If so you can not create combination charts with the 3d types. Cheers Andy osof wrote: Question, I want to make a stacked-column chart with horizontal lines and I can't seem to do it no matter what I do like even change the series. PLease help! |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
It's not the 3D type. It's just a stacked column with negative figures as
well and 3 horizontal lines. -- thank you! Mavy "Andy Pope" wrote: Hi, Is the stacked column the 3d variety? If so you can not create combination charts with the 3d types. Cheers Andy osof wrote: Question, I want to make a stacked-column chart with horizontal lines and I can't seem to do it no matter what I do like even change the series. PLease help! |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
I just created a stacked column chart with 4 series of data, including
negative values. Selected one of the series and right clicked form the context menu I picked Chart Type. Selected line chart. What have you tried? Cheers Andy osof wrote: It's not the 3D type. It's just a stacked column with negative figures as well and 3 horizontal lines. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
I've tried that as well but to no avail. it changed everything to lines..the
value of my line series are percentage. no matter what I do it won't work.. I have to manually add a trendline to form a line.. Help! someone said it's possible but they can't remember how they did it... -- thank you! Mavy "Andy Pope" wrote: I just created a stacked column chart with 4 series of data, including negative values. Selected one of the series and right clicked form the context menu I picked Chart Type. Selected line chart. What have you tried? Cheers Andy osof wrote: It's not the 3D type. It's just a stacked column with negative figures as well and 3 horizontal lines. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
If you want to email me directly an example I will take a look see.
Cheers Andy osof wrote: I've tried that as well but to no avail. it changed everything to lines..the value of my line series are percentage. no matter what I do it won't work.. I have to manually add a trendline to form a line.. Help! someone said it's possible but they can't remember how they did it... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
Here are sample values
0.00% 2005 ($28,000) $28,000 $47,000 $9,000 2006 (30,000) 42,000 50,000 11,000 330.80% I put the zero before 2005 because the line series are the percentage ones and it starts at 0. Thanks for all the help.I appreciate it... -- thank you! Mavy "Andy Pope" wrote: If you want to email me directly an example I will take a look see. Cheers Andy osof wrote: I've tried that as well but to no avail. it changed everything to lines..the value of my line series are percentage. no matter what I do it won't work.. I have to manually add a trendline to form a line.. Help! someone said it's possible but they can't remember how they did it... -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
Sorry but that data example doesn't really help as I can not figure out
what you are trying to plot. Are the years plotted as series? In which case you need more % values. If the stacks are for each year then you need to move the % values to the secondary axis and change the chart type to line. Cheers Andy osof wrote: Here are sample values 0.00% 2005 ($28,000) $28,000 $47,000 $9,000 2006 (30,000) 42,000 50,000 11,000 330.80% I put the zero before 2005 because the line series are the percentage ones and it starts at 0. Thanks for all the help.I appreciate it... |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
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% -- thank you! Mavy "Andy Pope" wrote: Sorry but that data example doesn't really help as I can not figure out what you are trying to plot. Are the years plotted as series? In which case you need more % values. If the stacks are for each year then you need to move the % values to the secondary axis and change the chart type to line. Cheers Andy osof wrote: Here are sample values 0.00% 2005 ($28,000) $28,000 $47,000 $9,000 2006 (30,000) 42,000 50,000 11,000 330.80% I put the zero before 2005 because the line series are the percentage ones and it starts at 0. Thanks for all the help.I appreciate it... |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
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 |
|
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Combination charts
-- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
