Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Labels for Charts
Hi,
I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Labels for Charts
usally the accuracy of the chart labels is the same format as the cells that
the chart is from. If you change the display option of the worksheet then the cells in the chart will change . I can create a macro to automatically change the charts. "Courtney" wrote: Hi, I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Labels for Charts
Thank you... I was hoping to be able to keep the data in the
worksheets as-is. Any way to still have the charts populate with no decimals? On Jan 20, 9:41*am, Joel wrote: usally the accuracy of the chart labels is the same format as the cells that the chart is from. *If you change the display option of the worksheet then the cells in the chart will change . *I can create a macro to automatically change the charts. "Courtney" wrote: Hi, I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Labels for Charts
Copy the data to another part of the worksheet and reformat the copied
section. Then plot the copied section. You can always use a formula in the copied section (=A1) so when you change the original data the copy and the chart also changes. "Courtney" wrote: Thank you... I was hoping to be able to keep the data in the worksheets as-is. Any way to still have the charts populate with no decimals? On Jan 20, 9:41 am, Joel wrote: usally the accuracy of the chart labels is the same format as the cells that the chart is from. If you change the display option of the worksheet then the cells in the chart will change . I can create a macro to automatically change the charts. "Courtney" wrote: Hi, I have charts that are based on dynamically populated data. I need the data labels for all of these charts to appear with 0 decimal places. The dynamic data populates with 2 decimal places (X.XX). Is there a universal setting I can apply to the worksheet or even the chart itself, so I do not have to go to each data point/data label and set the formatting to 0 decimal places? Thanks, Courtney |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data labels for charts | Charts and Charting in Excel | |||
data labels in charts | Charts and Charting in Excel | |||
Data labels on charts | Excel Discussion (Misc queries) | |||
Data Labels on charts | Charts and Charting in Excel | |||
Help with pivot charts and data labels | Charts and Charting in Excel |