H
Hyaenaman
I am not an expert by any stretch of the imagination in excel 2007 bu
have become very frustrated in trying to simply produce a scatter char
that does the following. I am tryin to produce a chart that shows sale
of 2 different products in specific areas. E.g. 190 towns each havin
sales figures for product 1 and also for product 2. If I just select th
sales data and produce the chart it works fine in that sales of product
are on X axis and product 2 sales on Y axis. But if I attempt to sho
the town in which the sales take place, i.e. still have sales on X and
and Y axes and the single points as towns I cannot get it to work. Th
chart always resorts to sales of a product on Y axis and the towns (a
numbers) on the X axis. Other product sales now displayed as a separat
point on chart. Not what I was looking for. The only way I hav
discovered to rectify this is to select data, edit each line and set a
a separate series for each row. This is ok for a few lines but not fo
the 190 that I wish to do. Is there a simple way of producing chart tha
I am looking for? Any help gratefully received.Just to confirm this i
for excel 200
have become very frustrated in trying to simply produce a scatter char
that does the following. I am tryin to produce a chart that shows sale
of 2 different products in specific areas. E.g. 190 towns each havin
sales figures for product 1 and also for product 2. If I just select th
sales data and produce the chart it works fine in that sales of product
are on X axis and product 2 sales on Y axis. But if I attempt to sho
the town in which the sales take place, i.e. still have sales on X and
and Y axes and the single points as towns I cannot get it to work. Th
chart always resorts to sales of a product on Y axis and the towns (a
numbers) on the X axis. Other product sales now displayed as a separat
point on chart. Not what I was looking for. The only way I hav
discovered to rectify this is to select data, edit each line and set a
a separate series for each row. This is ok for a few lines but not fo
the 190 that I wish to do. Is there a simple way of producing chart tha
I am looking for? Any help gratefully received.Just to confirm this i
for excel 200