LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default More than 255 data series

Is there any reasonable workaround for including more than 255 data series in
an Excel chart? Ideally, I need to be able to show over 1000 data series in
a chart.

Now, I know that you might question the legibility of a chart with that many
data series, so here is a chart with 255 data series:
http://www.cs.washington.edu/homes/d...from-excel.gif

This chart shows time series data for a person working on a problem and the
problem-solving stages they engage in during the process. It's basically 8
parallel timelines. I have written a macro that generates the timeline by
using essentially floating columns. However, this requires a large number of
data series to display the entire timeline... hence my question.

Altogether, the choice of 255 series seems arbitrary. While having an upper
limit theoretically prevents people from making bad charts, I've seen plenty
of bad charts with only 5 series.

kate
 
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
automatically expand chart data series as data is added jlarson Charts and Charting in Excel 1 March 9th 06 10:31 AM
2nd Axes - primary series data of only 1 series disappears! cheriw Charts and Charting in Excel 1 February 23rd 06 12:32 AM
how do I plot a data series against two series Frustrated in Sydney Charts and Charting in Excel 7 February 16th 06 04:24 AM
Displaying single and multiple data series.Single data series Donald Macleod Charts and Charting in Excel 2 January 30th 06 02:52 AM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM


All times are GMT +1. The time now is 04:44 AM.

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

About Us

"It's about Microsoft Excel"