Graphs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl - 28 Apr 2005 21:48 GMT

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

Reply to this Message

Debra Dalgleish - 29 Apr 2005 02:47 GMT

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

> 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

Signature

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

Reply to this Message