gradient

  1. H

    vba change gradient color in graph

    Dear Excell Expert, Im try to change my graph with gradient color using VBA. i do record VBA when changing color to gradient but i receive error notification as follows. object doesn't support my property or method i hereby send my VBA code . Sub gradient() ' ' gradient Macro ' '...
  2. H

    Help with Guage Colour gradient Fill

    Using a template I found on the internet I've created a thermometer guage linked to a formula in another sheet. The 'mercury' itself is a shape plotted with a fill based on the value of a cell. I've formatted the mercury level as a gradient fill using a red to green traffic light spectrum. The...
  3. B

    Copy Gradient Fill from one cell to another

    Trying to copy the background (plain and gradient fills) from one cell to another based on the Dropdown value selected in the first cell. The attached file has macros and conditional formatting. I'm able to make the following code work if I MANUALLY set the background fill and THEN type in a...
  4. N

    Gradient Conditional Formula across several cells

    This is kind of a piggy back to another forum "Adding Up Several Percentages". Basically I have a row of x's 98 cells out. With those 98 cells I want to try and get a gradient stretch across all cells at the same time. So if all 98 cells are not filled with an X i would like a percentage of it...
  5. P

    Conditional Formatting Gradient

    Hello, I have a table with data in columns C and D. In Column E, I have the difference between columns C and D, and then F is the percentage difference. I would like to have a two color gradient to color the high percentages, but only if the difference in column F is greater than 1. This is...
  6. A

    Adding Gradient to a Cell on Mac Excel 2011

    How do I add a two color gradient fill to a cell on a Mac Excel 2011? I can only figure out how to add it to a shape or a chart, but I need to add it to a single cell. Thank you!
  7. M

    Excel 2013 - Charts color scheme - gradient option

    Hi all, In 2013 charts, bar and line, the default option is a color scheme that doesn't demonstrate a change from lowest to highest (blue, grey, orange, etc.). I know that I can change colors manually for each data category, but it's extremely time-consuming when I have multiple categories. Is...
  8. P

    Chart Colour dependent on value

    Is there any way to get a bar chart's fill colour to vary depending on its value. We are looking to change the colour of the bar when it goes above 'a value' so the top sections will be red and lower sections remain all green. When a gradient is applied it applies it to the whole bar. We are...
  9. H

    Problem Setting BackColor.RGB dynamically for a shape gradient - value is out of range

    Hi peeps, I am using a row of autoshapes to show a key underneath a macro-cotrolled map made of other shapes, whose colour depends on various values. There is column of data for the key with ten rows; one for each shape in the key. This column of data holds RGB values for the shape colours, in...
  10. I

    contour (surface) chart and gradient series colors

    OK, complicated question. I'm trying to create a contour plot (one of the 2D surface charts) that shows a gradient of colors in the plot. As in, I want 100 different colors used in the plot area. BUT... I only want 10 basic colors shown in the legend as a reference. I got the 10 colors in the...
  11. K

    How Do I control the Gradient using VBA?

    Hello All, I have a Macro that inserts a WordArt object to simulate a Watermark. The problem that I'm having is that I cannot seem to control the Gradient Effect that's been applied to the text. I see how I can control the rotation and other properties of the WordArt Object, but I haven't...

Some videos you may like

This Week's Hot Topics

Top