2 Legends for Pareto Chart?

Hi,

I'm creating a Pareto Chart.

I have a primary data table that totals up total defects & graphically displays this through the data table & vertical bars on my primary axis.

I have a secondary axis that I would like to display the defect types or products as lines. I don't want these in my primary data table.

Is there a way to make another or second legend to display my secondary data collection? I don't need to include a data table. I attached a picture for reference.

Thanks

Try working with the Pareto Plotter available at Debra Dalgleish's website. Then let us know what you'd like it to do differently.
http://www.contextures.com/excelfilesRon.html#RCharts

Hi Ron,

Thanks for the info. It' quite informative & probably will be a good reference for future purposes. The 2nd legend almost looks like it can be done, but I'm not quite seeing how at the moment.

Probably should've mentioned this before, but I'm using Excel 2003. Can you or someone else explain how to get a 2nd legend in?

Thanks