Excel chart bug

[Zadig Galbaras]

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.

--

Regards
Zadig Galbaras
(nick)
-----

 

[Sandy Mann]

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.

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Earl Kiosterud]

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.
--
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...

 

[Zadig Galbaras]

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...

--

Regards
Zadig Galbaras
(nick)
-----

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.
--
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...
-----------------------------------------------------------------------

 

[Earl Kiosterud]

Nick,

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

--
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
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...