conditional formatting of columns in a column chart

N

Nikhil

Question
I have 2 data points for every store across 2 qtrs.

E.g:

Store Qtr1 Qtr 2
StoreX 2.5 5
StoreY 4.6 3.8
StoreZ 3.3 2.9

I want a column graph with the condition that if the Qtr 2 score is higher
than Qtr 1, then the column should be green in color and if it is lower than
Qtr 1, then it should be red in color. I will be having a different chart
for each store.

How can i do this?

Nikhil
 

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

Conditional columnar graph 1
how to change color gradients in a bar chart 0
Chart Object source data problem 5
Bar Chart with bar data and another bar showing a range of data 2
One column and 2 lines chart in single axis 7
comparing 2 values on one column in chart 8
Conditional Sum of 1 < Columns 6
assign permanent colors to bars/values in a pivot chart 1

Top