Tushar- You have opened a whole new world for me in excel - my 'sum' commands
are about the extent of my excel expertise and having a read of your 'dynamic
charts' is really quite inspiring. Thaks. I now need to work out how to graph
various variables of data across the one graph such as sales , number of
customers, time in store. for each store over a period of time.
Cheers
Mike

"Tushar Mehta" wrote:

Answering your specific question, create a column chart. Next, in the
chart, select the series you want as a line. Then, select Chart |
Chart Type... | and select the desired chart and sub-type.

To use a single chart for all the stores, adapt the ideas (particularly
example 6) in
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

Depending on how your data are organized, you may be able to create a
PivotTable and PivotChart. If so, you may find useful
PivotChart Drilldown
http://www.tushar-
mehta.com/excel/software/pivotchart_drilldown/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
This relatews to my previous post about '2 seperate clusters of bars...' (not
sure how to give the direct link here).

What I am struggling to do with basic excel skills is to gab the data of
several stores and showing each store performance by month for 2004 and
comparing this with those same months for 2005. There are 12 stores and moths
from July to December. I wuld like to be able to see all on one graph but so
far it is not looking very clear. SO... I have then thought of looking at
each store in it's own graph and using the Bar graph for months of 2005 and
have a line graph over / on the same graph for that store of the 2004 data so
show the trend and change in performance.

Is that posiible and how?

Thanks
Mike