Waterfall Chart

[Maxwell]

I made a waterfall chart but I cannot attach "BOTH" values
and lables on it. It only allow me to chosee 1 of them at
at time.

How do i do this without using any add-ins.

Just want to work off 'basic' excel.

Please advise

 

[Frank Kabel]

Hi
AFAIK without some add-in help not really possible.

 

[Tushar Mehta]

You are much better off using an add-in to automate the following.
But, you could always do by hand what the add-in automatically.
Data Labels
http://www.tushar-mehta.com/excel/newsgroups/data_labels/index.html
recommends the use of an add-in, but it also points to
Dynamic Chart Title
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_chart_title/index.html
since the same technique applies to chart titles and data labels.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Max -

Add a dummy line series, with points where you need your labels. Format the series to show no
lines and no markers. If the labels you want to show are not the values of this series, put
custom labels in a column, then use one of these free utilities to add the labels in those cells
to the data points.

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