Cost curve chart

[Saar Ben-Attar]

I am trying to create a cost-curve type chart, of 100 products originating
from 10 departments.

I made a list of 1-100, and defined it as the X-axis. The Y-axis is the
product profit margin.

If I list all 100 products in one series and sort the profit table, I can
see the cost curve but all points are of the same color and so I cannot
recognise which products are of which department.

If I define a series for each department (i.e.: 10 products), I can
recognise each department's products by means of a separate color, but the
graph does not resemble a cost curve.

It seems that perhaps a third variable is needed (a 1-100 listing, profit
and department). What type of chart should I use?

Any help would be most appreciated.

Saar Ben-Attar

 

[Tushar Mehta]

Create the chart so that all the points are the same color. That way
your curve looks as you want. Now, double-click the plotted series.
From the Options tab, select 'Vary colors by point'

--
Regards,

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