Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
larry
 
Posts: n/a
Default can i chart my data in the font color?

I would like my chart to display my data points in the color of the font i
enter them in . ie.... a red font would display a red bar and a black font a
black bar. Does anyone know if this is possible?

  #2   Report Post  
bj
 
Posts: n/a
Default

You would have to write a macro to do this automatically. If you only have a
couple of charts to do, You might want to just select the individual bar and
change the color yourself.

depending on the graph type selected, you could also separate out the data
into different series depending on the color you want to use, and plot using
a stacked bar chart

"larry" wrote:

I would like my chart to display my data points in the color of the font i
enter them in . ie.... a red font would display a red bar and a black font a
black bar. Does anyone know if this is possible?

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
Fan charts Dean Charts and Charting in Excel 7 May 30th 05 11:51 AM
pie-charting non-numeric data Gina O'Brien Charts and Charting in Excel 4 May 20th 05 12:23 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
change font color of first cell in data table attached to chart momo Charts and Charting in Excel 2 February 18th 05 01:47 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 09:16 PM.

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

About Us

"It's about Microsoft Excel"