Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shooter
 
Posts: n/a
Default simple chart question

I am missing a very simple step here. I would like to create a simple chart
that tracks two series of data. I am using the chart wizard and the one line
in the chart is picking up the data fine but I am missing the step to create
a second line on the same chart. Thanks for your help.
--
Shooter
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heidi
 
Posts: n/a
Default simple chart question

Shooter,

Go to ChartSource Data.

There are two tabs in the dialog box that opens. Go to the second tab,
"series". On the left side, click the "Add" button to add a new series.
Enter the appropriate x and y values in the areas to the right and below and
you should be all set.

In the future, when you make the chart, you can first hold down the control
key while selecting the different regions of your data. That will allow you
to select regions that aren't next to each other. Then, when you make your
chart, all your data will "probably" be included like you want.

Heidi

"Shooter" wrote:

I am missing a very simple step here. I would like to create a simple chart
that tracks two series of data. I am using the chart wizard and the one line
in the chart is picking up the data fine but I am missing the step to create
a second line on the same chart. Thanks for your help.
--
Shooter

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Chart Question s boak Charts and Charting in Excel 1 January 7th 06 02:14 AM
Simple Function question? jboss73 Excel Worksheet Functions 3 January 6th 06 02:22 PM
Pivot / general chart formatting question NTL Charts and Charting in Excel 0 December 5th 05 11:37 AM
pie-charting non-numeric data Gina O'Brien Charts and Charting in Excel 4 May 20th 05 12:23 PM
Area Chart Formatting Question Avrilon Charts and Charting in Excel 3 December 2nd 04 09:14 PM


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"