Make a separate column and write city or other values which you want to enter in graph. Select data labels and go to format data labels (already explain in video). Now select value from cells and select cells which contain your desired labels. Uncheck other option. Hopefully, your problem will be solved
Make a separate column and write city or other values which you want to enter in graph. Select data labels and go to format data labels (already explain in video). Now select value from cells and select cells which contain your desired labels. Uncheck other option. Hopefully, your problem will be solved
Watch this video to plot multiple data sets on the same chart in excel: ruclips.net/video/K5kIdA29L5g/видео.html
Little tricky but finally got the hang
🙂
Thanks 😊 👏👏☺☺
Welcome
Is this the only way to get all of the layers in the same color format??
yes
Where is mentioned city name?
How to understand which graph is from which city?
Please help.
Make a separate column and write city or other values which you want to enter in graph. Select data labels and go to format data labels (already explain in video). Now select value from cells and select cells which contain your desired labels. Uncheck other option. Hopefully, your problem will be solved
How do you identify which city is which graph? Please help urgently
Make a separate column and write city or other values which you want to enter in graph. Select data labels and go to format data labels (already explain in video). Now select value from cells and select cells which contain your desired labels. Uncheck other option. Hopefully, your problem will be solved
How to make 3 data in 1 pie chart ?
follow the same steps as you follow for adding second data series