PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Multiple data on 2 carts

Reply

Multiple data on 2 carts

 
Thread Tools Rate Thread
Old 10-03-2008, 08:31 PM   #1
PastaMan
Guest
 
Posts: n/a
Default Multiple data on 2 carts


I have a spreadsheet with a column of data that is either O or N.
The 2nd column is Either F or A
The 3rd is the date.
The fourth is a temperature.

I am supposed to produce seperate line charts. One for the O and one for
the N
I set up the auto sort feature which works great, but I have to produce 2
seperate charts, one showing the trend in "N" and one for the "O".

I had it done originally with a line graph showing the N and O. THe data is
so close that it blends together.

With the auto sort I can only show one at a time.

Is there a way to show the N on one chart and the O on another? Also I am
supposed to set this up so that any new data will show up on the graph.

Thank You in advance for any help or suggestions.

Chris T.

  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off