lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to draw a chart for the table below. I have 2 charts in one. I created 2 charts with different Axis (one is secondary).
So far so good. Then I wanted to delete the axis and right click on each chart and then click on "Add data labels". After adding Data Labels, I thought I do not need Y axis (primary and secondary) so I deleted them both but my chart scale changed and return like before (before clicking on second diagram and say Secondary axis). How can I fix that problem? I do not need axis, I only want to Add Data labels. I do not want to lose the way it was scaled when I click on Secondary axis. Thank you so much.
I want to draw a chart for the table below. I have 2 charts in one. I created 2 charts with different Axis (one is secondary).
So far so good. Then I wanted to delete the axis and right click on each chart and then click on "Add data labels". After adding Data Labels, I thought I do not need Y axis (primary and secondary) so I deleted them both but my chart scale changed and return like before (before clicking on second diagram and say Secondary axis). How can I fix that problem? I do not need axis, I only want to Add Data labels. I do not want to lose the way it was scaled when I click on Secondary axis. Thank you so much.