... I want to change a chart type ...

[Guest]

I have a "Line - Column" chart in my spreadsheet.

My Bars represent the month which is in a Linked Cell.

The Value of the Bars is a Dollar amount from a Linked Cell.

The Line represents a Target Dollar Value.

I would like to add a second line that would represent a count from a linked
range of cells.

Can I edit my existing chart, or do I have to create a new one? Could you
give me a few pointers?

Darrell

 

[Tushar Mehta]

Select and drag the new column onto the chart. In the resulting dialog
box, ensure you specify 'new series'. Once XL finishes adding the
series, if it is not the kind you want, select it in the chart and then
select Chart | Chart Type... Set the chart type as desired. Keep in
mind that when selecting a chart type with a single series selected
affects only that one series.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions