S
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
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