PC Review


Reply
Thread Tools Rate Thread

Help with series in the chart

 
 
TFL25
Guest
Posts: n/a
 
      2nd Jul 2008
I have 3 colums
1 = dates
2 = numbers
3 = names

I want to have each name on the X axis the dates on the Y axis and then i
want to graph the numbers for each date.

Please please can anyone help me?
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      2nd Jul 2008
How about this:

Put Dates in the first column, then use the second column for the numbers
for the first name, and each additional column for the numbers for each
additional name. In the first row, keep the first cell (above dates) blank,
and put the name into the cell above each column of numbers.

1-Jan-08
1-Jan-08
1-Jan-08
1-Jan-08


"TFL25" <(E-Mail Removed)> wrote in message
news:5AD0EA0B-E91C-4E8C-AC4F-(E-Mail Removed)...
>I have 3 colums
> 1 = dates
> 2 = numbers
> 3 = names
>
> I want to have each name on the X axis the dates on the Y axis and then i
> want to graph the numbers for each date.
>
> Please please can anyone help me?



 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      2nd Jul 2008
Sorry, Outlook Express sent without my permission.

Your data is not conducive to making a sensible chart. Rearrange the data
like this:

Put Dates in the first column, then use the second column for the numbers
for the first name, and each additional column for the numbers for each
additional name. In the first row, keep the first cell (above dates) blank,
and put the name into the cell above each column of numbers.

Amy Bob Cam Del Eve
1-Jan-08 1 3 5 7 9
2-Jan-08 2 3 4 6 8
3-Jan-08 1 2 3 5 9
4-Jan-08 2 3 4 6 8
5-Jan-08 3 4 5 6 7
6-Jan-08 2 3 4 5 6

Select the range, make a line chart with series in columns. You will have
one series per name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"TFL25" <(E-Mail Removed)> wrote in message
news:5AD0EA0B-E91C-4E8C-AC4F-(E-Mail Removed)...
>I have 3 colums
> 1 = dates
> 2 = numbers
> 3 = names
>
> I want to have each name on the X axis the dates on the Y axis and then i
> want to graph the numbers for each date.
>
> Please please can anyone help me?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Selectable Series and Number of Series for Line Chart Dave in NJ Microsoft Excel Charting 2 23rd Feb 2009 01:18 AM
how to plot column chart with one series against multiple series. =?Utf-8?B?c3ZlbmthdGVzaG11cnRoeQ==?= Microsoft Excel Charting 2 16th Oct 2007 10:09 PM
chart data series -- plot a table as a single series =?Utf-8?B?aGpj?= Microsoft Excel Charting 7 20th Sep 2005 06:52 PM
Multiple Series of Series in Stacked Column chart? nlee144(NoSpamTakeSquareRootOfNumber) Microsoft Excel Charting 2 5th Jun 2004 04:31 AM
can I hide a series in a stacked bar chart but keep the series in the data table jcknortheast Microsoft Excel Charting 1 5th Dec 2003 11:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:15 AM.