I am creating simple horizontal bar graphs using data such
as:

apples 10.9%
oranges 11.1%
banadas 78.0%

I want:
1) the bars' data labels to be accurate to one decimal
place.
AND
2) the y-axis labels to have no decimal places (ie:
20%,40%,... NOT 20.0% 40.0%,...)

If I change the data from the table to no decimals place,
I get 2) OK but then lose the accuracy I want in the data
labels.

Any advice?

Thank-you so much.
- Jane

Hi Jane,
1) Right click the y-axis, select Format axis from popup menu,
2) Open the Number tab and set the number of decimals to show
3) Right click on a data label value, select Format Data Label,
4) On Number tab set number of decimals to dimply

By the way- since your numbers on the y-axis, you are making a Column chart
not a Bar chart in Excel terminology
Any you should be talking about precision not accuracy.
Sorry for dropping into professor mode!
Best wishes
Bernard

"Jane" <(E-Mail Removed)> wrote in message
news:159f201c41666$c9ca9a70$(E-Mail Removed)...
> I am creating simple horizontal bar graphs using data such
> as:
>
> apples 10.9%
> oranges 11.1%
> banadas 78.0%
>
> I want:
> 1) the bars' data labels to be accurate to one decimal
> place.
> AND
> 2) the y-axis labels to have no decimal places (ie:
> 20%,40%,... NOT 20.0% 40.0%,...)
>
> If I change the data from the table to no decimals place,
> I get 2) OK but then lose the accuracy I want in the data
> labels.
>
> Any advice?
>
> Thank-you so much.
> - Jane

Hi Jane,

You should be able to format the Y axis to have no decimal places
without affecting the data labels.
Select Y axis press CTRL+1 adjust number format to suit.

Cheers
Andy

Jane wrote:

> I am creating simple horizontal bar graphs using data such
> as:
>
> apples 10.9%
> oranges 11.1%
> banadas 78.0%
>
> I want:
> 1) the bars' data labels to be accurate to one decimal
> place.
> AND
> 2) the y-axis labels to have no decimal places (ie:
> 20%,40%,... NOT 20.0% 40.0%,...)
>
> If I change the data from the table to no decimals place,
> I get 2) OK but then lose the accuracy I want in the data
> labels.
>
> Any advice?
>
> Thank-you so much.
> - Jane

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Many thanks to Andy and Bernard for their help. - Jane

Actually, Bernard, a bar chart has a vertical X axis and horizontal Y
axis, preserving the implied cause and effect.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Bernard V Liengme wrote:

> Hi Jane,
> 1) Right click the y-axis, select Format axis from popup menu,
> 2) Open the Number tab and set the number of decimals to show
> 3) Right click on a data label value, select Format Data Label,
> 4) On Number tab set number of decimals to dimply
>
> By the way- since your numbers on the y-axis, you are making a Column chart
> not a Bar chart in Excel terminology
> Any you should be talking about precision not accuracy.
> Sorry for dropping into professor mode!
> Best wishes
> Bernard
>
> "Jane" <(E-Mail Removed)> wrote in message
> news:159f201c41666$c9ca9a70$(E-Mail Removed)...
>
>>I am creating simple horizontal bar graphs using data such
>>as:
>>
>>apples 10.9%
>>oranges 11.1%
>>banadas 78.0%
>>
>>I want:
>>1) the bars' data labels to be accurate to one decimal
>>place.
>>AND
>>2) the y-axis labels to have no decimal places (ie:
>>20%,40%,... NOT 20.0% 40.0%,...)
>>
>>If I change the data from the table to no decimals place,
>>I get 2) OK but then lose the accuracy I want in the data
>>labels.
>>
>>Any advice?
>>
>>Thank-you so much.
>>- Jane
>
>
>

Quite right - I was having a senior moment!
Bernard

"Jon Peltier" <(E-Mail Removed)> wrote in message
news:ekl%(E-Mail Removed)...
> Actually, Bernard, a bar chart has a vertical X axis and horizontal Y
> axis, preserving the implied cause and effect.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> http://PeltierTech.com/Excel/Charts/
> _______
>
> Bernard V Liengme wrote:
>
> > Hi Jane,
> > 1) Right click the y-axis, select Format axis from popup menu,
> > 2) Open the Number tab and set the number of decimals to show
> > 3) Right click on a data label value, select Format Data Label,
> > 4) On Number tab set number of decimals to dimply
> >
> > By the way- since your numbers on the y-axis, you are making a Column
chart
> > not a Bar chart in Excel terminology
> > Any you should be talking about precision not accuracy.
> > Sorry for dropping into professor mode!
> > Best wishes
> > Bernard
> >
> > "Jane" <(E-Mail Removed)> wrote in message
> > news:159f201c41666$c9ca9a70$(E-Mail Removed)...
> >
> >>I am creating simple horizontal bar graphs using data such
> >>as:
> >>
> >>apples 10.9%
> >>oranges 11.1%
> >>banadas 78.0%
> >>
> >>I want:
> >>1) the bars' data labels to be accurate to one decimal
> >>place.
> >>AND
> >>2) the y-axis labels to have no decimal places (ie:
> >>20%,40%,... NOT 20.0% 40.0%,...)
> >>
> >>If I change the data from the table to no decimals place,
> >>I get 2) OK but then lose the accuracy I want in the data
> >>labels.
> >>
> >>Any advice?
> >>
> >>Thank-you so much.
> >>- Jane
> >
> >
> >
>