View Single Post
  #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