D
Deleted member 2227
Guest
Sorry if this is dim, but how can I produce some very simple graphs?
Last edited by a moderator:
ADY1983
MB Enthusiast
- Joined
- Jan 31, 2006
- Messages
- 1,787
- Location
- Yeovil, Somerset
- Car
- 300CE-24 Sportline, MK1 Golf GTI Campaign Edition, Scirocco GTII
Use Excel, type in your numbers and then click the Icon at the top that looks like a bar chart. 
Hope that helps?
Hope that helps?
OP
OP
Deleted member 2227
Guest
Cheers!! I'm off to have a play!
OP
OP
Deleted member 2227
Guest
I'm having trouble getting the X axis label with each year?
Last edited by a moderator:
SG CL500
Active Member
Put the data in a 2 row (1st row = year, 2nd = data) x (however many you need) column format with the first column being "year" (r1) then "data" (r2) - highlight the entire data then click the graph button and it should work straight away.
i.e.
_____2000 2001 2002 2003 2004 ...
Data 0.45 0.43 0.68 0.89 0.21 ...
If you have the data as above and it only has intermediate years then you need to double click the X axis and, choose the "Scale" tab from the pop-up and ensure the "number of categories between X axis labels" and "number of categories between tick marks" is set to 1.
i.e.
_____2000 2001 2002 2003 2004 ...
Data 0.45 0.43 0.68 0.89 0.21 ...
If you have the data as above and it only has intermediate years then you need to double click the X axis and, choose the "Scale" tab from the pop-up and ensure the "number of categories between X axis labels" and "number of categories between tick marks" is set to 1.
Last edited:
OP
OP
Deleted member 2227
Guest
Column A is the number range which has become the Y axis
The years are in row 11?
The years are in row 11?
ADY1983
MB Enthusiast
- Joined
- Jan 31, 2006
- Messages
- 1,787
- Location
- Yeovil, Somerset
- Car
- 300CE-24 Sportline, MK1 Golf GTI Campaign Edition, Scirocco GTII
Right click and format axis, number and change to dates.R2D2 said:
SG CL500
Active Member
You need the data in a simple table with years going across row 1 and the data in the cells below & legend going down column A - doesn't sound like you do.
masqueraid
Active Member
- Joined
- May 22, 2006
- Messages
- 911
- Car
- E220 CDi & A170CDi
Excellent advice already here.
You might find this page helpful as well, especially the sections on dialogue boxes, where you tell Excel which data you want plotted and on what axis.
You might find this page helpful as well, especially the sections on dialogue boxes, where you tell Excel which data you want plotted and on what axis.
OP
OP
Deleted member 2227
Guest
Thanks guys! I'm getting there. ......slowly!
Users who are viewing this thread
Similar threads
