Chart Source Data

[Scott R]

Hi there was wondering if anyone could help me on this.. Im creating a chart
from 3 rows of data at the top of the worksheet. The numbers in this data
have up to 8 decimal places. I dont want any decimal places however when i
format these cells the formatting only then applies to the values on my chart
axis. The values up the top of the worksheet still remain displayed as 8 dec
places?

 

[ryguy7272]

Format the cells separately: select the cells containing data, right-click,
format cells, number, decimal places.

Hope that helps.
Ryan---

 

[Scott R]

Hi Ryan,

Ive tried that, doesnt work. If you select the cells at the top it will
automatically format the axis but wont format the cells ive selected.