Adding a new data series to an existing chart

W

Whitaker

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
 
Top