Nov 03 2021 09:05 PM
Nov 03 2021 09:37 PM
@zainab_alsaeed You probably did not highlight the data range(s) to be plotted. Look at the tutorial in the attached link to see how it works.
Nov 04 2021 12:55 AM - edited Nov 04 2021 12:55 AM
@zainab_alsaeed Have a look at the attached file. I inserted a column chart. Click in either of the charts and on the Chart Design ribbon, choose Select Data. See how my chart is set up and compare it to yours. Then you'll see that yours is pointing to the wrong range for the data and the horizontal axis labels.
Nov 04 2021 03:21 AMSolution
Easiest would be to move the Amount column to right of the months. Select both the months and the amounts. Insert and select chart type.
Select F3:F6 (amounts), Insert, select the type of chart and that chart will appear instantly.
Now select G3:G6 (months). Ctrl-C (i.e. Copy).
Select the horizontal axis labels on the chart (still showing 1,2,3,4). Ctrl-V (i.e. Paste).