C
Cheryl
The consultant I work with has devised a cool waterfall chart in Excel that
uses some pretty elaborate formulas to get its values, and we haven't had
much success in using an embedded Excel chart in Powerpoint to display it in
a presentation. The results are not predictable, and we're developing it for
some not so savvy users. So we are simply copying the resulting data table
values into a Powerpoint chart datasheet that has been completely formatted,
which is working fairly well.
There are several series in the chart that are actually invisible, but he
uses the series name in the data label to put text above the stacked columns
of the other series. That part works fine.
The challenge is, he wants the positive or negative sign to appear in front
of these numbers, + or -. It works fine in the Excel spreadsheet using a
formula to add them in as text in front of the number resulting from the rest
of the formula, but when we copy that to the datasheet in Powerpoint, it sees
the number and strips out the + sign from the positive numbers. And for the
negative numbers, it defaults back to the parentheses instead of using the -
sign.
We created a custom number format to handle this in the Powerpoint
datasheet, but when we copy the data in, it reverts to the default format. I
need to find a way to create a macro that will, when a button is pushed in
normal view, select the custom format for these series titles.
Is this even possible?
uses some pretty elaborate formulas to get its values, and we haven't had
much success in using an embedded Excel chart in Powerpoint to display it in
a presentation. The results are not predictable, and we're developing it for
some not so savvy users. So we are simply copying the resulting data table
values into a Powerpoint chart datasheet that has been completely formatted,
which is working fairly well.
There are several series in the chart that are actually invisible, but he
uses the series name in the data label to put text above the stacked columns
of the other series. That part works fine.
The challenge is, he wants the positive or negative sign to appear in front
of these numbers, + or -. It works fine in the Excel spreadsheet using a
formula to add them in as text in front of the number resulting from the rest
of the formula, but when we copy that to the datasheet in Powerpoint, it sees
the number and strips out the + sign from the positive numbers. And for the
negative numbers, it defaults back to the parentheses instead of using the -
sign.
We created a custom number format to handle this in the Powerpoint
datasheet, but when we copy the data in, it reverts to the default format. I
need to find a way to create a macro that will, when a button is pushed in
normal view, select the custom format for these series titles.
Is this even possible?