Forum Discussion
Solved
Can´t edit the label in column grafic
i need to edit labels for my categories in order to mach witch my data. but only can edit the first column label
The easiest solution is to click in the 'Chart data range' box and then to select B10:D13.
As you see, this assigns meaningful names to the chart series and fixes the x-values.
After that, you should select the Attrition series and plot it on the secondary axis:
Result:
See the attached workbook.
ok, here attach de excel:
https://www.dropbox.com/scl/fi/5ufyd0j6n92kadpn6s7ke/GraficDataExample.xlsx?dl=0&rlkey=1bchowcwo1o2rnhfx984149as
https://www.dropbox.com/scl/fi/5ufyd0j6n92kadpn6s7ke/GraficDataExample.xlsx?dl=0&rlkey=1bchowcwo1o2rnhfx984149as
The easiest solution is to click in the 'Chart data range' box and then to select B10:D13.
As you see, this assigns meaningful names to the chart series and fixes the x-values.
After that, you should select the Attrition series and plot it on the secondary axis:
Result:
See the attached workbook.
- thanks a lot, I thought to solve it differently