Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 23rd 04, 07:01 PM
Kerri Buxton
 
Posts: n/a
Default multiple or changing colours in a data table on an excel chart fo.

We are trying to have the "negative" numbers in a data table (under the
chart) show in red, like the data series, but seem unable to alter the format
unless it is for all data. (we're trying to highlight or bring attention to
the negative variances) The data labels will follow the excel font's but the
data table does not appear to.

Any suggestions?

  #2   Report Post  
Old December 23rd 04, 07:53 PM
John Mansfield
 
Posts: n/a
Default

Kerri,

Unfortunately the formatting options for data tables are fairly limited. As
a result, it's not possible to apply different font formatting to different
cells or rows within any one data table. If you are using an embedded chart,
you can build the data table in worksheet cells which should allow for the
type of formatting you're asking for.

----
Regards,
John Mansfield
http://www.pdbook.com

"Kerri Buxton" wrote:

We are trying to have the "negative" numbers in a data table (under the
chart) show in red, like the data series, but seem unable to alter the format
unless it is for all data. (we're trying to highlight or bring attention to
the negative variances) The data labels will follow the excel font's but the
data table does not appear to.

Any suggestions?

  #3   Report Post  
Old December 23rd 04, 08:39 PM
Jon Peltier
 
Posts: n/a
Default

Hi Kerri -

In addition to the approach John suggests (which I happen to use frequently), you
could read what Tushar Mehta says about data tables on his web site:

http://tushar-mehta.com/excel/newsgr...able/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

John Mansfield wrote:

Kerri,

Unfortunately the formatting options for data tables are fairly limited. As
a result, it's not possible to apply different font formatting to different
cells or rows within any one data table. If you are using an embedded chart,
you can build the data table in worksheet cells which should allow for the
type of formatting you're asking for.

----
Regards,
John Mansfield
http://www.pdbook.com

"Kerri Buxton" wrote:


We are trying to have the "negative" numbers in a data table (under the
chart) show in red, like the data series, but seem unable to alter the format
unless it is for all data. (we're trying to highlight or bring attention to
the negative variances) The data labels will follow the excel font's but the
data table does not appear to.

Any suggestions?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 17th 04 12:07 AM
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 08:31 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017