Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Debbie
 
Posts: n/a
Default Adding a line Chart Type to a stacked-clustered Chart Type

I have columns and stacked columns side by side in a chart. I tried to
add another data point, but as a line instead of a column. The line does not
appear on the chart itself but does show as a data series in the legend. I
have an example I could email but not sure how to attach to these messages.


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Debbie -

What does your data look like? Is the data (X & Y) for the line within the same
range as the columns?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Debbie wrote:

I have columns and stacked columns side by side in a chart. I tried to
add another data point, but as a line instead of a column. The line does not
appear on the chart itself but does show as a data series in the legend. I
have an example I could email but not sure how to attach to these messages.



  #3   Report Post  
John Mansfield
 
Posts: n/a
Default

Debbie,

This should get you a column - stacked column - line chart . . .

Try setting up your data as follows:

Series 1 Series 2 Series3 Series4 Line 1 Line 2
Jan 1 4 5
3 5 4
3 2 6 5
Feb 2 5 6
3 6 7
3 3 7 6
Mar 3 6 5
3 5 6
2 2 4 7
Apr 4 5 6
3 6 5
2 4 5 4
May 5 6 5
3 7 6
3 3 4 7

With this setup and taking January as an example, the effect that youre
trying to achieve is to have 3 total columns €“ two columns are normal, the
third column is stacked, and there are two lines above the columnar group.
The first two columns are single columns side by side consisting of the data
1 and 3. Next to those two columns is your stacked column consisting of the
data 3 and 2. The Series3 and Series4 titles are dummies for legend purposes
only. The Line1 and Line2 columns will eventually be the lines.

Step 1 €“ based on the setup above, create a stacked column chart.

Step 2 €“ Click once on Series "Line1" column segment- right click on your
mouse - Chart Type - Line - OK.

Step 3 - Click once on Series "Line2" column segment - right click on your
mouse - Chart Type - Line - OK.

Step 4 - Delete the "Line 1" and "Line 2" legend keys from the legend.

Step 5 - Click on the Series 1 legend key and color it purple.

Step 6 - Click on the Series 2 legend key and color yellow.

Step 7 - Click on each 2nd bar within each month and color them yellow to
correspond with the yellow legend key.

Step 8 - Click on Series 3 and color it green.

Step 9 - Click on each 3nd bar within each month and color them green to
correspond with the green legend key.

Step 10 - Click on Series 4 and color it plum.

Step 11 - Click on each 4th bar within each month and color them plum to
correspond with the plum legend key.

Step 12 €“ Decrease the gap widths for the columns and format the lines.

If you could respond to Jon's question, it would be interesting to get his
input on how to put this together. Hopefully there's an easier method.

----
Regards,
John Mansfield
http://www.pdbook.com



"Debbie" wrote:

I have columns and stacked columns side by side in a chart. I tried to
add another data point, but as a line instead of a column. The line does not
appear on the chart itself but does show as a data series in the legend. I
have an example I could email but not sure how to attach to these messages.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add line to a stacked area chart already created Mitch Charts and Charting in Excel 3 April 3rd 23 04:43 PM
Combination of stock chart and line chart hwatari Charts and Charting in Excel 2 September 24th 07 10:52 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Adding a text label to a line. Neil Charts and Charting in Excel 1 December 4th 04 09:41 PM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"