Graphs

HELP. I am trying to create a graph with 4 days figures in it in bar format.
I then want to add a line which would be the average figures. When I try and
do this the graph puts days 3 and 4 in line format. I can add more serires
to it and this gets rid of it. Must be a easier way

Create a bar chart from all the data
Right-click on the series that you want as a line
Choose Chart Type
Select the Line Chart type, and one of the subtypes
Click OK

carl wrote:
> HELP. I am trying to create a graph with 4 days figures in it in bar format.
> I then want to add a line which would be the average figures. When I try and
> do this the graph puts days 3 and 4 in line format. I can add more serires
> to it and this gets rid of it. Must be a easier way


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html