Graph with multiple inputs

**BlueBoy** · 03-08-2009, 03:28 PM

Good evening, great forum; a little help if I may...

Trying to construct a line graph in Excel 2003 with the following requirements: -

X axis needs to have 25 dates for start of weeks - 6-months worth obviously
The Y axis needs to show 4-sets of data, left to right with a trendline which can be updated weekly

I'm confused how I get the dates to show and even more confused how to show 4-sets of data - I have the data sheet and can construct the graph but can't seem to enter the data accurately.

Help please...

Thanks - BB

**zbor** · 03-08-2009, 03:41 PM

Something like this?

Attachment 38374

Just take all data and show in chart you want...

**BlueBoy** · 03-08-2009, 03:48 PM

Yes, spot on thank you - I still not clear how to represent the data correctly; adding series etc - any useful links?

BB

**zbor** · 03-08-2009, 04:01 PM

Right click on chart -> Select data -> add or remove or edit existing data

**arthurbr** · 03-08-2009, 04:05 PM

Moved to charts forum

**BlueBoy** · 03-08-2009, 04:13 PM

Thank you - all done.

BB

Ps. Sorry for the incorrect forum!

**BlueBoy** · 03-08-2009, 04:22 PM

Actually, there is one more thing :-)

How do I turn the dates at the bottom on their end so I can fit a huge amount more in? I.e. from horizontal to vertical?

Brilliant, thank you - BB

**BlueBoy** · 03-08-2009, 04:37 PM

Done it... He he, and my FINAL question - the date range on the graph is currently monthly but the date range on the data sheet is weekly.

I have checked the X axis and it does show the full data range - how do I show the whole lot on one chart?

Thanks - Blue