First, I am not an Excel wiz.

I have percentage data and Excel's formatting allows to show such data with
the percentage sign in the cell. I need to automatically create bar charts
for these data through a macro and would like to show the data value, e.g.,
35%. However, when creating the bar chart using Excel's chart wizard, the
data are not interpreted as percent but as 0.35 in the above example and as a
result the bar is too short, ie it is 0.35 units long and not 35 on a scale
from 0 to 100.
Is there a way to show the data value as 35% and have the bar be of the
correct length?
Thanks for all help and suggestions.

"Tanja Srebotnjak" <Tanja (E-Mail Removed)> wrote in
message news:79A321FE-75F9-4DD6-B3B3-(E-Mail Removed)...
> First, I am not an Excel wiz.
>
> I have percentage data and Excel's formatting allows to show such data
> with
> the percentage sign in the cell. I need to automatically create bar charts
> for these data through a macro and would like to show the data value,
> e.g.,
> 35%. However, when creating the bar chart using Excel's chart wizard, the
> data are not interpreted as percent but as 0.35 in the above example and
> as a
> result the bar is too short, ie it is 0.35 units long and not 35 on a
> scale
> from 0 to 100.
> Is there a way to show the data value as 35% and have the bar be of the
> correct length?
> Thanks for all help and suggestions.

Format axis/ number/ percentage
--
David Biddulph