GMC The Macro Man
Board Regular
- Joined
- Mar 23, 2023
- Messages
- 102
- Office Version
- 2021
- Platform
- Windows
Hi there
I am trying to edit the legend entries on a chart and I'm using the Select Data Source as I just want to change it on the actual chart, not on the Data Source, however the buttons are grayed out.
The Data Source worksheet is in Table format and is NOT protected and I have looked everywhere for a solution but cannot find one.
Can anyone help?
I am trying to edit the legend entries on a chart and I'm using the Select Data Source as I just want to change it on the actual chart, not on the Data Source, however the buttons are grayed out.
The Data Source worksheet is in Table format and is NOT protected and I have looked everywhere for a solution but cannot find one.
Can anyone help?