colouring in bars on a chart to correspond to quartiles

G

Graham Whitehead

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
Adding Percentages to a Stacked Chart 1
Stacked column chart narrow bars wanted 5
error bars on bar chart in Excel 2007 1
getting a pivottable to automatically pick up new rows in the source? 3
different colors for bars in a column chart 2
Customise error bars on individual bars in a bar chart 2007 2
Format Category Labels 2

Top