Adding a new data series to an existing chart

G

Guest

I have a stacked bar chart that shows monthly sales by customer type. I want to add an additional data series to show the monthly forecast, to be displayed as a point or line against the existing stacked-bar data. Any ideas?
 
T

Tushar Mehta

Select the data you want to plot. Drag onto the chart. XL will pop up
with a dialog box asking for some information. Provide it and you will
be all set.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
J

Jon Peltier

Well, the new data is likely to be added by Excel as another stack.
Right click on the new stack, choose Chart Type, and select a Line type
for the series.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a Second and Third Line to an Existing Stacked Bar/Line Cha 3
Table within a chart 4
Combine stacked column and line chart w/series lines 1
Stacked Columns with different series in each column 0
Automate chart X-axis/data 1
Stacking data from within a series within a bar chart 1
How can i create a 2-D stacked column within a 4 series stock char 6
Adding a series to an existing Stacked Bar Chart 1

Top