RU2084
asked on
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rory Archibald
Do you have Office 2007 SP2 applied? Also, does it make a difference if you set a different default printer?
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,
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,
ASKER
@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 .
@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...
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...
<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.
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.
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. :)
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. :)
>>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>
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>
ASKER
@teylyn thanks a mil for your advice, your input is very much appreciated.