Graph assistance (2003 SP3

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Graph assistance (2003 SP3

Post by steveh »

Morning all

Can somebody give me some graph advice please, the first picture below shows where I am getting my data from and the second is the graph but you will notice that the plot areas double the value from the data source. Any ideas please?
You do not have the required permissions to view the files attached to this post.
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
Top
User avatar
sdckapr
3StarLounger
Posts: 392
Joined: 25 Jan 2010, 12:21

Re: Graph assistance (2003 SP3

Post by sdckapr »

Use a line chart. It seems that you have a stacked line-chart. In the stacked, you list the increase, so what plots for the 1st series is the 1st series, but what plost for the 2nd is the sum of the 1st and 2nd...

Steve
Top
steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Sorted - Graph assistance (2003 SP3

Post by steveh »

Hi Steve

Thanks for that, I don't know why I even choose that type!! It is probably because I rarely use charts but I saw a good tool on the J Walk web site and was trying to do it myself without copying anything.

Ta
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
Top

Return to “Excel and other spreadsheet applications”