Chart Source Data
 

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?

Chart Source Data
 

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

Hope that helps.
Ryan---

--
RyGuy


"Scott R" wrote:

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?

Chart Source Data
 

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.

"ryguy7272" wrote:

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

Hope that helps.
Ryan---

--
RyGuy


"Scott R" wrote:

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?