View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
jonfaris
 
Posts: n/a
Default Totals in 3d bar graph don't add up correctly

Thanks, Bernard! I just switched the charts back to regular bar graphs, and
it all looks correct...

Best,
Jon

"Bernard Liengme" wrote:

And that is exactly why many authors warn about using the 3D effect - it
distorts the data.
The 3D effect is what the charting expert Tufte called "chart junk" or when
he is being polite, "gratuitous decoration".
Thank you for a nice example for the book I am working on!
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jonfaris" wrote in message
...
When I highlight a range of data to create a 3D bar graph with the Charts
Wizard and follow the steps, the resulting bars do not match up with the
original data. For example, I have five different fiscal years for my
company and their corresponding budget:

FY07 Actual FY08 FY09 FY10
FY11
$81,173.00 $260,244.20 $453,499.79 $576,582.05 $704,575.88

When I put these in a chart, the bars do not line up correctly (i.e. the
FY11 bar only reachs to just below the $700,000 line, rather than just
above
it).

Any suggestions?

Thanks,
Jon