Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
rmellison
 
Posts: n/a
Default Line chart or scatter chart??

I have many sets of data for which the x-values run up from approx 60 to 100,
and back down to 60ish. Each set of data consists of 200 points. I can
happily display each set individually on a scatter chart, with the categories
from, 60 (at point i=1)to 100 (i=100) to 60 (i=200). My probably occurs when
I want to display two sets of data on the same graph. For each set, the
x-values vary, for example another set could run from 65 to 95 then back to
65, but it still contains 200 points. Excel will only allow one set of values
on the category axis, so only one data set will be correctly represented by
the x-values. Using a scatter graph uses numerical x-values rather than
categories, so my x-values only go from 60ish to 100ish, which is not what i
want.

Is there any way to use numerical values on a line chart, and have each data
set represented correctly against the x-axis? Or similary can I create a
scatter graph with x-values running from 60 to 100 to 60?

Any help greatly appreciated.

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
Line chart or scatter chart?? rmellison Excel Discussion (Misc queries) 2 September 7th 05 12:04 PM
Creating a line chart with two X-axes!! JaVaughn Excel Discussion (Misc queries) 1 June 30th 05 01:36 PM
Label an average line in a dynamic chart John Cordes Charts and Charting in Excel 3 June 17th 05 09:42 AM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 10:38 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"