| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
colouring in bars on a chart to correspond to quartiles
Hi, I was wondering if anyone know if it is possible to colour code the bars
in a column chart corresponding to their value, i.e. in my case I want the upper and lower quantiles to be different colours. Would this involve evaluating the value of each point in the chart and coluring it, or would it involve collecting calling each range as a seperate series and adding them on. I am at a complete loss with this one and any suggestions would be gratefully received. Many thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
colouring in bars on a chart to correspond to quartiles
http://peltiertech.com/Excel/Charts/...nalChart1.html
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Graham Whitehead" wrote in message ... Hi, I was wondering if anyone know if it is possible to colour code the bars in a column chart corresponding to their value, i.e. in my case I want the upper and lower quantiles to be different colours. Would this involve evaluating the value of each point in the chart and coluring it, or would it involve collecting calling each range as a seperate series and adding them on. I am at a complete loss with this one and any suggestions would be gratefully received. Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display quartiles and median in a chart? | Charts and Charting in Excel | |||
| Urgent Help - Plot Quartiles as vertical lines in Chart | Charts and Charting in Excel | |||
| Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
| determine colouring of variables of a pie chart | Charts and Charting in Excel | |||
| Pie Chart Colouring - for top surface of slices only | Charts and Charting in Excel | |||
Hybrid Mode
