how do I add series lines to a an excel stacked chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kalan - 04 Sep 2006 17:46 GMT

Hi,

I accessed the Help Menu for this Q. and it says that I have to go to
-Format-Select Chart Area-Options Tab. Here, I'd have to select the type of
lines I want to use to link a data point on a stacked bar with other data
points of the same type on all other stacked bars I have on my chart.

I want to use series lines as compared to drop lines or high-low
lines...However, there are no line options in the Options Tab. The only
options I have are: Gap Depth, Gap Width, and Chart Depth.

Seems like an error on the Help Menu? Can anyone tell me how can I use
series lines. Thanx.

Reply to this Message

Jon Peltier - 05 Sep 2006 03:16 GMT

You should really avoid using chart types with fake 3D styling. In addition
to being unable to use many features of 2D charts, 3d charts are notorious
for distorting their data and for being difficult to interpret. Some people
think they "look nice", but it's not worth losing information and clarity to
make some marketing types or managers think the chart "looks nice".

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

> Hi,
>
[quoted text clipped - 10 lines]
> Seems like an error on the Help Menu? Can anyone tell me how can I use
> series lines. Thanx.

Reply to this Message

kalan - 05 Sep 2006 09:58 GMT

Thanks. I didn't know series lines couldn't be used in 3-D charts.

Kalan.

> You should really avoid using chart types with fake 3D styling. In addition
> to being unable to use many features of 2D charts, 3d charts are notorious
[quoted text clipped - 23 lines]
> > Seems like an error on the Help Menu? Can anyone tell me how can I use
> > series lines. Thanx.

Reply to this Message