I have a dashboard of graphs in excel. All the graphs are kept on one sheet with the corresponding data all in separate tabs. I have an issue with two of the charts on the dashboard always being formatted to a lavender color for the column charts and a yellow color for a goal line in the column chart. Also, the data labels on another chart keep disappearing. These two formatting changes only occur when certain data is updated in the data sheets. Does anyone have a clue what could cause this? If I ever plan on automating the updating of the dashboard, this is going to be a huge problem if I can't keep my original formatting intact. Thanks!
-
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.
Weird formatting issues in Excel graphs
- Thread starter hutchisd
- Start date
Excel Facts
Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
GlennUK
Well-known Member
- Joined
- Jul 8, 2002
- Messages
- 11,871
- Office Version
- 2019
- 2013
- Platform
- Windows
OK. Can you explain exactly what's happening here:
... what is the issue? Are you saying that these charts are always the wrong colour? Or is that you always want these charts to always be those colours, but Excel changes them? Or what?I have an issue with two of the charts on the dashboard always being formatted to a lavender color for the column charts and a yellow color for a goal line in the column chart.
Upvote
0
Similar threads
- Replies
- 0
- Views
- 677
- Question
- Replies
- 0
- Views
- 897
- Replies
- 7
- Views
- 645
- Replies
- 1
- Views
- 445
