LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lasci
 
Posts: n/a
Default Area chart - missing values

Hi all,

I have been creating graphs using the stacked area type to display data for
data by year. However I have some years that have missing data. This then
plots as zero. I have been to tools, options, charts and clicked interpolate
for missing values but this doesn`t seem to work for the stacked area
chart...has anyone else found this? Has anyone found an acceptable work
around?
I`d be interested if anybosy has found anything similar, thanks in advance
for any help.
 
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 without numerical values Fred Geiger Charts and Charting in Excel 3 September 26th 05 08:02 AM
Missing lines in chart w/x-axis with months 1-24... DendWrite Charts and Charting in Excel 2 May 10th 05 09:04 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 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 03:52 PM.

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"