Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Line chart, multiple series, data is inter-mixed

I'd like to avoid having to sort and arrange my data, so I'm wondering
if it is possible
to create a category-based line chart with several series, but with
the source data intermixed. The category to which each data point
belongs appears in a cell directly
adjacent to the data cell.

In other words, can I tell Excel that I'd like to chart a several
series from a data
range, and provide a 2nd range which defines the categories of the
corresponding
data points?

For example, my data might be in four categories (calories, speed,
temp, weight) with
five data points in each category, and might appear in the worksheet
like this:

calories 3500
speed 65
temp 98.6
weight 185
calories 4000
speed 68
temp 99.0
weight 170
calories 3320
speed 46
temp 102.5
weight 192
calories 3400
speed 50
temp 98.6
weight 187
calories 4000
speed 68
temp 99.0
weight 170

Previously, I've solved this by sorting into four separate regions,
then define the
chart's four series out of each region.

But this doesn't scale easily, as I will be routinely creating charts
containing
over 30,000 data points distributed among 14 categories.

Thanks,
-Bob
Andover, MA

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Line chart, multiple series, data is inter-mixed

This is one time you can't skip steps; you have to explicitly tell Excel
which data to plot. These are all Y variables; what are you using for X? And
why aren't you creating your table in record format, with one column per
field?

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


"Bob" wrote in message
oups.com...
I'd like to avoid having to sort and arrange my data, so I'm wondering
if it is possible
to create a category-based line chart with several series, but with
the source data intermixed. The category to which each data point
belongs appears in a cell directly
adjacent to the data cell.

In other words, can I tell Excel that I'd like to chart a several
series from a data
range, and provide a 2nd range which defines the categories of the
corresponding
data points?

For example, my data might be in four categories (calories, speed,
temp, weight) with
five data points in each category, and might appear in the worksheet
like this:

calories 3500
speed 65
temp 98.6
weight 185
calories 4000
speed 68
temp 99.0
weight 170
calories 3320
speed 46
temp 102.5
weight 192
calories 3400
speed 50
temp 98.6
weight 187
calories 4000
speed 68
temp 99.0
weight 170

Previously, I've solved this by sorting into four separate regions,
then define the
chart's four series out of each region.

But this doesn't scale easily, as I will be routinely creating charts
containing
over 30,000 data points distributed among 14 categories.

Thanks,
-Bob
Andover, MA



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default Line chart, multiple series, data is inter-mixed

On Thu, 26 Apr 2007, in microsoft.public.excel.charting,
Bob said:
For example, my data might be in four categories (calories, speed,
temp, weight) with
five data points in each category,


Previously, I've solved this by sorting into four separate regions,
then define the
chart's four series out of each region.

But this doesn't scale easily, as I will be routinely creating charts
containing
over 30,000 data points distributed among 14 categories.


If you populated the column to left with a formula like
IF(B3="calories",A2+1,A2) you would have a range like so:

A B C
1 calories 3500
1 speed 65
1 temp 98.6
1 weight 185
2 calories 4000
2 speed 68
2 temp 99
2 weight 170
3 calories 3320
3 speed 46
3 temp 102.5
3 weight 192
4 calories 3400
4 speed 50
4 temp 98.6
4 weight 187
5 calories 4000
5 speed 68
5 temp 99
5 weight 170

Can you make a pivot table or pivot chart out of that to look like this?

A calories speed temp weight
1 3500 65 98.6 185
2 4000 68 99 170
3 3320 46 102.5 192
4 3400 50 98.6 187
5 4000 68 99 170
----------------------------------------
18220 297 497.7 904

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
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
Why Color Flled Data Series on Line Chart Slants MP246AZ Charts and Charting in Excel 5 April 28th 07 08:01 PM
Why does Excel line chart cut off my data series? snowbound Charts and Charting in Excel 4 August 2nd 06 12:19 PM
Refreshing pivot makes second data series line disappear from chart !!! WhytheQ Excel Discussion (Misc queries) 4 July 4th 06 01:28 PM
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 1 January 21st 05 03:17 PM
In mixed bar and line chart. I cannot change one of my source da. bluetractorboy Charts and Charting in Excel 0 January 21st 05 02:57 PM


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