Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unstacking a series of data on a 3-D chart
I want to stack two series of data in one column and show a third series on
the column next to it on a 3-D chart. How do I unstack the third series of data? |
#2
|
|||
|
|||
Try to stagger your data before you build the chart, so where the first
two series are stacked, there's no value of the third series, and where there is a third series column, the first two have no values: Series 1 Series 2 Series 3 value value value value value value value value value Make sure your series are plotted by column. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ldsun wrote: I want to stack two series of data in one column and show a third series on the column next to it on a 3-D chart. How do I unstack the third series of data? |
#3
|
|||
|
|||
Jon, I saw this post, tried the technique and I can confirm that it works but
what would I do for X category labels if, for example, series 1 and 2 referred to 2003 and 2004 respectively and staggered series 3 also referred to 2004? "Jon Peltier" wrote: Try to stagger your data before you build the chart, so where the first two series are stacked, there's no value of the third series, and where there is a third series column, the first two have no values: Series 1 Series 2 Series 3 value value value value value value value value value Make sure your series are plotted by column. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ldsun wrote: I want to stack two series of data in one column and show a third series on the column next to it on a 3-D chart. How do I unstack the third series of data? |
#4
|
|||
|
|||
"Referred to" means category labels? Do you need to stagger series 2 & 3
on the same row? I'm not sure what you're asking. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KG wrote: Jon, I saw this post, tried the technique and I can confirm that it works but what would I do for X category labels if, for example, series 1 and 2 referred to 2003 and 2004 respectively and staggered series 3 also referred to 2004? "Jon Peltier" wrote: Try to stagger your data before you build the chart, so where the first two series are stacked, there's no value of the third series, and where there is a third series column, the first two have no values: Series 1 Series 2 Series 3 value value value value value value value value value Make sure your series are plotted by column. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ldsun wrote: I want to stack two series of data in one column and show a third series on the column next to it on a 3-D chart. How do I unstack the third series of data? |
#5
|
|||
|
|||
Combination of typos and poor choice of words! Furthermore I may be following
the wrong lead by focusing on this specific thread. In order to keep things clean, I shall experiment a little further with my own specific challenge and, if I still need help, I shall post a separate request. I visit your website regularly and I will certainly look there for applicable techniques before I post. Thanks! "Jon Peltier" wrote: "Referred to" means category labels? Do you need to stagger series 2 & 3 on the same row? I'm not sure what you're asking. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ KG wrote: Jon, I saw this post, tried the technique and I can confirm that it works but what would I do for X category labels if, for example, series 1 and 2 referred to 2003 and 2004 respectively and staggered series 3 also referred to 2004? "Jon Peltier" wrote: Try to stagger your data before you build the chart, so where the first two series are stacked, there's no value of the third series, and where there is a third series column, the first two have no values: Series 1 Series 2 Series 3 value value value value value value value value value Make sure your series are plotted by column. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ldsun wrote: I want to stack two series of data in one column and show a third series on the column next to it on a 3-D chart. How do I unstack the third series of data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
One data series and two y-axes in an Excel chart? | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |