• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 96
  • Last Modified:

Excel graphs

I have an excel spreadsheet with pie charts and when I open the spreadsheet I am not able to view the graphs as they are originally.It takes a while for the graphs to open completely as I scroll up & down. Is there maybe a reasonable explanation why this happens?. I have  attached the spreadsheet. Z1---Z2-Work-hrs-vs-Lost-hrs.xls
0
RU2084
Asked:
RU2084
  • 3
  • 3
  • 2
  • +1
1 Solution
 
pritamduttCommented:
it opens fine on my system. Probably it takes time to recompute on open which may be causing the delay.
0
 
Rory ArchibaldCommented:
Do you have Office 2007 SP2 applied? Also, does it make a difference if you set a different default printer?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This is not for points and does not offer a solution to your problem ....

BUT  ... (I cannot resist)

<soapbox>

Do not use pie charts for more than three data points.

Do not use 3D charts in any form.

The worst possible combination is a 3D pie chart. (The only thing that tops it in un-usability is a 3D clustered column chart)

If you want to create charts that the reader finds easy to understand and interpret, have a read of this: http://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf

You'll probably dismiss this. Who the hell am I to tell you which chart type to use, anyway?

But if you are remotely interested in getting the crucial information contained in the data across to the reader,  then you may want to find out more about good data visualisation as opposed to Excel defaults and 3D glitz.
</soapbox>

cheers,
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RU2084Author Commented:
@pritamdutt I also think it is the delay, any clue what might be causing that delay @rorya I'll check if I have MS Office sp2 installed or not .
0
 
Rory ArchibaldCommented:
@teylyn,
Your comments prompted to me to actually download and open the file, and my retinas are now melting down my face. Thanks. ;)

Slight disagreement with your numbers - pie is ok for 2 or fewer data points. But then of course you don't need a chart anyway...
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
<mark calendar: knowledge xfer from t to r, very unusual>

Among the three best books ever written, at least about data visualisation:

Show me the numbers
Now you see it
Information Dashboard Design

All well-thumbed through on my desk, but some managers still "want" pie charts. Working on it.

Two or three to a pie is debatable. S Few is good, but not God.

0
 
Rory ArchibaldCommented:
I was referring to the OP's workbook, not the pdf!
I have the first two Few books but not the third, so may get that (have some Tufte too)

the disagreement re numbers was my opinion and I of course am God. :)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
>>pie is ok for 2 or fewer data points

I like to tear into pies with one data point only. With my teeth.

>> the OP's workbook, not the pdf!
<deflate>
<erasing calendar markings>
0
 
RU2084Author Commented:
@teylyn thanks a mil for your advice, your input is very much appreciated.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now