Show both value and percentage on Waterfall Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim - 28 Sep 2005 18:55 GMT

Hi folks,

I need a help on my waterfall chart. I want to show both percentage and
value on my waterfall chart and move the value to the top of the bars (and
keep on the top of bars) instead of in the middle of the bars. Could anyone
show me how to do it? Any help will be deeply appreciated.

Thanks in advance.

Tim

Reply to this Message

Jon Peltier - 28 Sep 2005 19:50 GMT

Tim -

For this, add a series to the chart. For X values, use the category labels of the
waterfall data. For Y values, use the value at the top of the visible bar(s) at each
category. Construct the label text in a parallel worksheet range.

After adding the series (it'll probably be another stacked bar), select it and
change it to a line chart using Chart menu > Chart Type. Then use one of these free
Excel add-ins to apply labels to this series using the range you added above:

Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)

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

> Hi folks,
>
[quoted text clipped - 6 lines]
>
> Tim

Reply to this Message

Tim - 29 Sep 2005 16:57 GMT

Jon,

Thanks a lot.

Tim.

> Tim -
>
[quoted text clipped - 27 lines]
> >
> > Tim

Reply to this Message