Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / October 2006

Tip: Looking for answers? Try searching our database.

Formatting Labels Using Code

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
juliejg1 - 25 Oct 2006 16:00 GMT
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?
Jon Peltier - 25 Oct 2006 23:28 GMT
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
_______

>I have a stacked column chart based on data as follows:
> 2005 Exchange Volume Inflation Price
[quoted text clipped - 13 lines]
> higher
> than zero to be put in brackets?
juliejg1 - 26 Oct 2006 14:14 GMT
Works perfectly...Thanks!!

> Apply a custom number format of
>
[quoted text clipped - 26 lines]
> > higher
> > than zero to be put in brackets?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.