Hi,

Im using Excel 2003 and lets say I have sales data on 30 stores in
which specific promotions were run (Test Stores). Since its a
consolidate monthly data so I have 30 data points only. I also have
average sales of 30 other stores very similar to test stores in which
no promotions were run (Control Stores) which means 1 data point.

I want to compare the sales data of each of the test stores with the
average test store sales and also the average control store sales in a
single graph.

My idea was to draw a column graph with each bar representing sales for
each of the test stores. Then I can draw 2 straight lines in this graph
with each of the lines representing the average test and control store
sales. I have 3 series with me, with 1st series having data on test
stores, 2nd series having average test store sales for 30 data points
and similarly the 3rd series for average control store sales.

Subsequently I chose line-column type chart with 1st series as column
and second series as line. I want 3rd series also to be line but it is
showing up as column only. How to manpulate it

(I dont want line representation for all 3 series, as it doesnt make
sense to show 1st series as line. Neither do I want to plot my 3rd
series on secondary axis).

Pls guide me.

regards,
HP
India