chart colours

  1. V

    how to create a control chart

    Hi, I've used trend lines to find the mean and average but for some reason I have not been able to set an upper and lower limit. without introducing a new column. Please do let me know if there's a way around this. Thanks
  2. N

    How to change an area chart series type

    I have a chart with three data series plotted on it. Series1 is a line, Series2 and Series3 are area chart series types. I have figured out how to change the forma/color of the line, but it is proving to be quite difficult for the area series. For the line I used...
  3. A

    Preventing chart colours to change when source data is changed - Excel 2003

    Hi, When I change the source data of a chart, the chart colours change automatically. Can anyone suggest how can this be prevented? (If the solution is in VBA, it is more than welcome) Thanks, Ankita
  4. A

    Charting help: Series colour from None to anything

    Hello everyone. I have a stacked bar chart with up to 8 series per category. I have (intentionally) made the 1st series bar format have no line and no fill, therefore making it invisible. I would like to retrieve this series but cannot select it so I can modify the format. Can anyone...
  5. B

    Scorecard pie, column and spot colour changes

    Folks I am trying to build a scorecard for my company. Unfortunately I have a legacy of Word for reporting and am using linked images at this stage to replace the previous manually updated word charts etc. My evil plan is to use Excel as a data source for all the various dots, charts, pie charts...

Watch MrExcel Video

This Week's Hot Topics

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
Top