Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Labels Using Code
I have a stacked column chart based on data as follows:
2005 Exchange Volume Inflation Price Blank 1,862 1,844 1,844 2,210 Up 0 93 0 402 0 Down 0 111 0 36 The 'Down' values are actually negative amounts but have to be shown as positives for the chart to work properly. My question is, I woulld like the lables in the chart for the 'Down' values to be put in brackets to represent negative numbers. However, since the values have to be positive for this chart to function properly, simply changing the formatting on the cells will not work. Is there code I can write for this chart to show any values higher than zero to be put in brackets? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Labels Using Code
Apply a custom number format of
"("0")" Apply it to the Down data and to the data labels for the Down series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "juliejg1" wrote in message ... I have a stacked column chart based on data as follows: 2005 Exchange Volume Inflation Price Blank 1,862 1,844 1,844 2,210 Up 0 93 0 402 0 Down 0 111 0 36 The 'Down' values are actually negative amounts but have to be shown as positives for the chart to work properly. My question is, I woulld like the lables in the chart for the 'Down' values to be put in brackets to represent negative numbers. However, since the values have to be positive for this chart to function properly, simply changing the formatting on the cells will not work. Is there code I can write for this chart to show any values higher than zero to be put in brackets? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formatting Labels Using Code
Works perfectly...Thanks!!
"Jon Peltier" wrote: Apply a custom number format of "("0")" Apply it to the Down data and to the data labels for the Down series. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "juliejg1" wrote in message ... I have a stacked column chart based on data as follows: 2005 Exchange Volume Inflation Price Blank 1,862 1,844 1,844 2,210 Up 0 93 0 402 0 Down 0 111 0 36 The 'Down' values are actually negative amounts but have to be shown as positives for the chart to work properly. My question is, I woulld like the lables in the chart for the 'Down' values to be put in brackets to represent negative numbers. However, since the values have to be positive for this chart to function properly, simply changing the formatting on the cells will not work. Is there code I can write for this chart to show any values higher than zero to be put in brackets? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Questions | New Users to Excel | |||
chart with map underlay / formatting / labels / suggestions? | Charts and Charting in Excel | |||
There is a bug in formatting charts data labels. | Excel Worksheet Functions | |||
Change case...help please | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |