scales

  1. S

    powerpoint table to have color scales similar to excel

    In excel under conditional formatting, there is a color scale option where if I highlight a table and choose a color scale, Excel will automatically highlight my cells with different shades of green, yellow and red, depending on my value. I have a VBA code that currently copies each value in my...
  2. N

    Conditional formatting: Colour scales with additional criteria

    I don't think this is possible, but you never know. In the sample data below, I would like to apply colour scales to A,B,C and D, ignoring the sub-total and Total. I know I could apply CF to all 6 rows and then apply a 2nd rule that forces the sub-total and Total row to be displayed as white...
  3. M

    Changing axes on multiple charts in multiple sheets (VBA)

    Hi folks. I posted this before but got no replies so I’m simplifying to see if I get more luck. :confused: I have 4 sheets (A,B,C,D) each with 4 charts (renamed Chart1, Chart2 etc) I want to change the scales (in my code these will differ) but for this purpose can you let me know why this...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top