Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Excel chart bug

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Zadig Galbaras - 24 Jun 2007 15:34 GMT
hi...

I think I have found a bug in Excel 2007.

I have this spreadsheet containing a series of observed numbers, and last
years numbers are this years budget.
Then I make a chart to easily see the result of this years numbers compared
with last year.
This chart I made in nice 3D.

Take a look at this picture now.
http://www.tresfjording.com/images/excelbug.jpg

The red column to the left and the green column to the right is both
representing the value of 14002.
But it seems that MS has missed out on the 3D rendering of the chart, and
the column which should end just above 14000 ends in fact a little short of
14000.

I think this time the error is not mine.
And that's a pity because the information this chart gives away, is wrong.

Signature

Regards
Zadig Galbaras
(nick)
-----

Sandy Mann - 24 Jun 2007 15:59 GMT
Isn't this just the prospective illusion for the 3-D effect?  Does XL2007
have the functionality that XL97 has of altering the Elevation and Rotation
when you right-click on the chart and select 3-D View...?  When I do that in
XL97 with your figures and set the Elevation and Rotation to 0 it proves
that the columns are the right size.

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk

> hi...
>
[quoted text clipped - 17 lines]
> I think this time the error is not mine.
> And that's a pity because the information this chart gives away, is wrong.
Earl Kiosterud - 24 Jun 2007 16:20 GMT
Nick,

I think it appears to fall short of 14002 because of the viewing angle.  You're getting
parallax.  Try this:

Click the background part of the plot area, such as between gridlines.  There should now be
handles in the 8 corners of the 3D plot area.

Click one of those handles.  Nothing will happen, but it's just something that seems to be
needed.

Now drag that handle slightly.  The plot area should move around in 3D space.  Hold the Ctrl
key as you drag.  You can move it so that you're looking more directly on to the plot area,
instead from somewhat above as your currently are.

To make it more apparent, do this:

Set your Y axis to a maximum of 20,000 (Right click one of the Y labels and choose Format
axis - Scale tab).

Change one of your cells you're plotting to 20,000.  Now the associated column should go to
the top of the plot area.  Change the angle (first part of my post), holding Ctrl as you do
so.  It won't appear to go to the top of the plot area (20,000) while you're viewing from
above or below.

I don't think the 3D view was meant for accurate scale work.  It's more for comparative.
And just pretty.
Signature

Earl Kiosterud
www.smokeylake.com

   Note: Top-posting has been the norm here.
   Some folks prefer bottom-posting.
   But if you bottom-post to a reply that's
   already top-posted, the thread gets messy.
   When in Rome...
-----------------------------------------------------------------------

> hi...
>
[quoted text clipped - 16 lines]
> I think this time the error is not mine.
> And that's a pity because the information this chart gives away, is wrong.
Zadig Galbaras - 24 Jun 2007 19:10 GMT
Thanks Earl...
I saw this earlier on, and thought, rightfully so, that the columns wasn't
attached to the back wall of the chart, but rather was standing a distance
in front of it, and the angle of view is making it possible to look at the
back wall behind the columns.

The handles you were talking about did show up, but I couldn't change the
view by dragging those. Couldn't grab them so to speak.
But right clicking on the same spot came up with a menu with the option 3D
Rotation. In there I could play around with the view.

This is not a bug after all. :-(

But thanx anyway... :-)

Signature

Regards
Zadig Galbaras
(nick)
-----

> Nick,
>
[quoted text clipped - 46 lines]
>> And that's a pity because the information this chart gives away, is
>> wrong.
Earl Kiosterud - 26 Jun 2007 00:54 GMT
Nick,

Do you try clicking one of the handles, then a second attempt to drag them?

Signature

Earl Kiosterud
www.smokeylake.com

   Note: Top-posting has been the norm here.
   Some folks prefer bottom-posting.
   But if you bottom-post to a reply that's
   already top-posted, the thread gets messy.
   When in Rome...
-----------------------------------------------------------------------

> Thanks Earl...
> I saw this earlier on, and thought, rightfully so, that the columns wasn't attached to the
[quoted text clipped - 57 lines]
>>> I think this time the error is not mine.
>>> And that's a pity because the information this chart gives away, is wrong.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.