LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bev Bev is offline
external usenet poster
 
Posts: 28
Default "Chart Data Range is too complex to be displayed"

Is it time to give up and try something else if the formulas I inserted in my
spreadsheet, analysed in four series of chart data, give me a bar chart
result of 1 squished down tiny line, and the above message when I go to edit
the data?

The chart dialog box also says any data range change will over write all
data in the chart. And the choice I have for row or column selection has
been changed, with any new selection being greyed out.

What was done and what was the object:

created three IF statements comparing START and FINISH data
created a column for major project heading, Deliverable
tried to display completed, in process and not started tasks

formulas seemed to work, based on what was in the output and what the
formula bar indicated.

Ideas?

Bev
 
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
How to Match and Sort two range of data? Tan New Users to Excel 1 March 5th 06 10:30 PM
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
ranking query JaimeTimbrell Excel Discussion (Misc queries) 2 February 16th 06 08:09 AM
Inserting a new line when external data changes Rental Man Excel Discussion (Misc queries) 0 January 11th 06 07:05 PM
data range Steve M Excel Discussion (Misc queries) 0 April 4th 05 11:17 PM


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