Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fan charts | Charts and Charting in Excel | |||
pie-charting non-numeric data | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |