Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to add line to stacked-clustered chart?
hi, i've read John Mansfield's solution at http://www.excelforum.com//showthread.php?t=332217 but it's not quite what i'm after since for the line i only have one data point per cluster/month and not three as in his example... ideally i would like to add a line series to Bernard Liengme’s stacked-clustered chart example at http://www.stfx.ca/people/bliengme/E...ps/Columns.htm as my charts are based on it and i like his x-axis labelling format... thanks in advance for any help, anthony -- hifert ------------------------------------------------------------------------ hifert's Profile: http://www.excelforum.com/member.php...o&userid=19992 View this thread: http://www.excelforum.com/showthread...hreadid=345801 |
#2
|
|||
|
|||
Could you add the line series as an XY Scatter series? use the same X
values as for the X Axis helper series. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ hifert wrote: hi, i've read John Mansfield's solution at http://www.excelforum.com//showthread.php?t=332217 but it's not quite what i'm after since for the line i only have one data point per cluster/month and not three as in his example... ideally i would like to add a line series to Bernard Liengme’s stacked-clustered chart example at http://www.stfx.ca/people/bliengme/E...ps/Columns.htm as my charts are based on it and i like his x-axis labelling format... thanks in advance for any help, anthony |
#3
|
|||
|
|||
hi jon, unfortunately here xy scatter series only displays data point markers and not a line - any other suggestions? thanks, anthony -- hifert ------------------------------------------------------------------------ hifert's Profile: http://www.excelforum.com/member.php...o&userid=19992 View this thread: http://www.excelforum.com/showthread...hreadid=345801 |
#4
|
|||
|
|||
The XY Scatter type can display markers or no markers, a line or no
line, any combination. When you change the chart type, you have a choice of many variations of scatter styles. Then later, if you picked the wrong type, double click on the series, and choose relevant options on the Patterns tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ hifert wrote: hi jon, unfortunately here xy scatter series only displays data point markers and not a line - any other suggestions? thanks, anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add line to a stacked area chart already created | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Clustered column chart with stacked coumns | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |