Help with Excel
#1
Scooby Regular
Thread Starter
Join Date: Nov 1998
Posts: 11,905
Likes: 0
Received 0 Likes
on
0 Posts
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
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
#2
Scooby Regular
Join Date: Aug 2001
Location: Warrington
Posts: 4,554
Likes: 0
Received 0 Likes
on
0 Posts
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.
then use an XY scatter graph with different series for a, b, c, with X and Y being the date and the value respectively.
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
bluebullet29
General Technical
9
05 October 2015 02:17 PM