Jon Peltier wrote:
You can create your own combination chart types very easily. Make a line
chart with all of your data, select the Sales series in the chart, go to
Chart menu Chart Type, and select the Clustered Column type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


Thanks a lot for your response. I chose the sales series and did right
click -- Chart type. There are 2 tabs Standard Types and Custom types.
In both I see lots of varieties of charts but there is no "Clustered
Column" variety in it. I also tried choosing the "User-Defined" radio
button within Chart Type but it is displaying only the "default" which
is fully column type for all series.

Please let me know as to where Im going wrong.

Also, I see something strange. When I select any chart series it
selects alternate points starting from the first point in the series. I
undertsand that even when it selects aternate points it actually
selects the whole of the series, but why has MS designed it to not
select all points

regards,
HP
India


"Hari" wrote in message
oups.com...
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