ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   colors change in graphic (https://www.excelbanter.com/excel-programming/444953-colors-change-graphic.html)

Albatros

colors change in graphic
 
Dear,
i have a excelsheet with data that is imported from acces en excel.
In this excelsheet i need a grafic with that change color if the some
imported data change and go above data.

The data is:
the results of the month of this year.
the results of all months of last year
and the budget of those months.

The Graphics is a simple grafiek with 1 line and 1 block for every month
that
is past for this year.
The line is the budget.
The blok is the result for month x (in total ad the end of this year there
are 123 blocks.
Now my question.
Can i let the coler of those blocks change.
The change is as follow:
If the month result is higher than budget = Green
If the month resukt si lower than budget but higher than 2010 = orange
It the month reuslt is lower than budget and result 2010 = red.

How can i do this please.
thanks in advange.


Javed

colors change in graphic
 
consider using conditional formatting in excel interface


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com