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

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

In article <E--dneT0WavhkVrdRVn-(E-Mail Removed)>, (E-Mail Removed)
says...
> 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
>
>
>