chart format

  1. M

    Excel Chart - number formatting as decimal only if decimal values are available in source data

    I am having chart based on power pivot where values for all the months are updated based on slicer Selection. (E.g. Profit, Profit%.) I am currently using this number format "#,##0_);[Red](#,##0)" for chart labels which is available by default in excel. This format hides decimal values...
  2. X

    Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  3. D

    Pivot Chart Formatting not being maintained when I slice the data

    using Excel 2013... Thanks up front for any assistance from anyone! I have a pivot chart that whenever I start clicking through the timeline slicer it eventually (or immediately) returns to the original formatting. I have two values, one on primary and one on secondary axis, and I lose this...
  4. K

    VBA to select Line charts and format

    Hello, I have just really started to code on VBA but mainly from looking through such forums and using code from other macro's. I have the following problem and feel i am just missing one simple piece of the puzzle as they say. I need a macro when activated will do the following; will look...
  5. G

    Chart Format Mass Update

    I have 85 charts formatted identical. I would like to know if it is possible to update all of the charts at the same time to change the default automatic chart border color button to the no line button in Office 2010. Thanks

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