Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Help with Excel

Thread Tools
 
Search this Thread
 
Old 13 March 2006, 01:18 PM
  #1  
boxst
Scooby Regular
Thread Starter
 
boxst's Avatar
 
Join Date: Nov 1998
Posts: 11,905
Likes: 0
Received 0 Likes on 0 Posts
Default Help with Excel

Hello

I want to do a graph and I can't figure out which one / how to do it!

I have three columns:


a 1/2/03 4
a 3/4/04 5
b 1/1/03 7
c 1/2/03 2


So the first column is text group, then date then a number. The data is sorted by column a then b. I want to show the variations in the first column over the date range.

Any suggestions?

Thanks,

Steve
Old 15 March 2006, 01:07 AM
  #2  
speedking
Scooby Regular
 
speedking's Avatar
 
Join Date: Aug 2001
Location: Warrington
Posts: 4,554
Likes: 0
Received 0 Likes on 0 Posts
Question

If you mean that a was 4 on 1/2/03, then 5 on 3/4/04; and b was 7 on 1/1/03; etc.

then use an XY scatter graph with different series for a, b, c, with X and Y being the date and the value respectively.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
leg200
Subaru Parts
5
07 October 2015 07:31 AM
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
bluebullet29
General Technical
9
05 October 2015 02:17 PM



Quick Reply: Help with Excel



All times are GMT +1. The time now is 11:26 PM.