Help please-Open office/Excel>draw graph..

C_Mababejive

Hi all

I have been playing around with this for a while but cant seem to get it right.

I have one set of data in pounds and pence that represents a weekly payment

I want my vertical axis to be in pounds/pence

I want the horizontal axis to be marked out in weeks with each item being a week ending date(Saturday)

I want to display a graph which shows the week ending date against its corresponding payment.

***************

At the moment the payment is one lump sump but it is actually made up of two separate components A and B

One i get the basic graph right, how could i further enhance it to show two lines on the same graph representing quantities A,B and A+B

Thanks for any clues

maas

Can you not just add another data series to the graph, so you have 1 line representing A and another line representing B.

I have a similar dataset but I use a stacked column chart which breaks up each part of the payment in 1 block.

spud17

Stacked column is the way to go.
I use this with gas and electricity bills to show total energy cost.

Any help?
http://www.textndata.com/forums/discuss-stacked-bar-charts-48182.html

agrinnall

This is for Excel (2010).

A stacked column chart might do it. So your data in the worksheet looks like this:

Date Amount A Amount B
14-Feb £28.00 £3.00
21-Feb £35.00 £5.00
28-Feb £19.00 £6.00
07-Mar £24.00 £2.00
14-Mar £31.00 £4.00
Etc.

On the Insert tab select Column and the middle option of 2D columns (stacked column). That'll inset the basic chart, then click on Select Data, and select all of the data, including the headings.

The resulting chart will show a column with Amount A in blue and Amount B in red for each Saturday date. You may need to play around with the horizontal axis (click in the axis values and right click then Format axis - changing major and minor unit to fixed 7 days just leaves the Saturday dates, but doesn't get rid of the space for the other days of the week so it looks slightly odd).