I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41 will be the same for series2. Is there a way to do this (either in VBA or not)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Display my chart's font fill color and transparency percentage for all series on a "Chart Details" range of cells
Excel Facts
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Similar threads
- Question
- Replies
- 0
- Views
- 666
- Question
- Replies
- 1
- Views
- 4K
- Replies
- 0
- Views
- 492
