LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change graphic chart color bar based on name? Jimic Charts and Charting in Excel 1 July 16th 09 11:07 PM
Change graphic chart properties Israel Excel Discussion (Misc queries) 3 June 17th 08 06:20 PM
Excel bar chart formatting of bars to change colors as data change JudyT Excel Discussion (Misc queries) 1 January 24th 07 06:07 PM
Change event -- cell colors change Mr. Dan[_2_] Excel Programming 1 January 16th 07 09:45 AM
change colors L. Setting up and Configuration of Excel 2 November 28th 05 09:07 PM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"