Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 21st 14, 01:30 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2011
Posts: 46
Default Bar chart gradient fills

I have a bar chart that displays data for each day of the month. The
values range between 0 and 100 and the bars currently hold a gradient
fill that changes from green at the bottom, through orange at the
half-way point and then to red at the top.

However, each bar, not matter how long (other than 0!) shows the full
gradient whereas I would prefer only the appropriate section of gradient
to be displayed: green changing to green/orange at, say 25%; green
changing to green/orange and then orange at 50%; green changing to
green/orange to orange to orange/red at 75% etc.

Is this possible in Excel 2010?

--
F

www.vulcantothesky.org - keep the last remaining Vulcan flying

Reply
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
Color gradient problem on X-Y chart PaulPW Charts and Charting in Excel 2 May 21st 10 04:07 PM
how do I remove gradient fills in 07 ribbons and excel tabs sjok Setting up and Configuration of Excel 0 April 30th 09 09:52 PM
Bug with gradient fills and max scale Marcus Charts and Charting in Excel 1 March 7th 07 02:58 PM
Gradient of line chart Robert Hargreaves Charts and Charting in Excel 2 June 5th 05 06:44 PM
color gradient in a worksheet (not a chart), Is it Possible? Jamnew Excel Worksheet Functions 1 May 10th 05 09:57 PM


All times are GMT +1. The time now is 05:19 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017