How to format an isolated value and gridline on my graph?

#1 05-28-2005, 11:05 PM

I want to highlight a goal value on a 3D chart. I would like to highlight a
single value on the value axis and the corresponding major gridline. How can
I do this?

#2 05-29-2005, 01:05 PM

Duncan -

First, your ability to apply certain embellishments to a 3D chart is
severely limited. I always recommend against 3D charts for this reason,
and for the reason that they tend to distort the presented data in order
to get the 3D effects. Depending on your goals, distortion might not be
a bad thing <g>, but I tend to shy away from it.

In a 2D chart, you can add a point, then use an error bar as a gridline,
and apply a data label to the point with the value you're highlighting.
The following web pages describe how this can be done:

http://peltiertech.com/Excel/Charts/AddLine.html
http://peltiertech.com/Excel/Charts/...Gridlines.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Duncan Landreth wrote:

> I want to highlight a goal value on a 3D chart. I would like to highlight a
> single value on the value axis and the corresponding major gridline. How can
> I do this?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)