Adding a new data series to an existing chart

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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
 
Back
Top