| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pie chart & column chart w/same source data | Charts and Charting in Excel | |||
| Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Source data for a Chart | Excel Discussion (Misc queries) | |||
| Chart data source | Charts and Charting in Excel | |||
Hybrid Mode
