LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Series Lines Handling of Missing Data

I have a stacked bar chart with three series, and I'd like to connect
categories across all three series using series lines. One of the
series has an empty category, which I'm placing as the last (top) item
on each stacked bar.

There is a nice way to manage how line charts handle missing data, but
series lines don't seem to behave the same - they are all either on or
off. Is there way to use series lines but force them to leave gaps when
plotting the empty cell?

 
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
restricting the drop lines to only a single series z.entropic Charts and Charting in Excel 3 August 31st 05 03:04 AM
How do I change a data series from bars to lines in an Excel char. mrocke Charts and Charting in Excel 1 March 29th 05 01:41 AM
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Format Data Series Markers KB Charts and Charting in Excel 1 November 30th 04 03:37 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


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