Forum Discussion
talmania
Feb 29, 2024Copper Contributor
Can't Format Chart Correctly
I want to make a chart showing the total spend of each specific account ID. In column A, I have the ID, and then in the corresponding column B, I have the total spend for the account. I want to make ...
HansVogelaar
Feb 29, 2024MVP
Click anywhere in the chart.
On the Chart Design tab of the ribbon, click Select Data.
Under Legend Entries (Series), select the first series and click Edit.
Select the contents of the Series values box and copy it.
Click Cancel.
Next, click Edit under Horizontal (Category) axis labels.
Clear the contents of the Axis label range box, then paste.
Click OK.
Now select the first series again and click Remove.
Finally, click OK.