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 03 2021 11:17 PM
@zainab_alsaeed Difficult to help if you don't share your file.
Nov 04 2021 12:38 AM
@Riny_van_Eekelen thank you to help me , this is the file called priblem
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 02:49 AM
Nov 04 2021 03:21 AM
SolutionEasiest would be to move the Amount column to right of the months. Select both the months and the amounts. Insert and select chart type.
Otherwise:
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).
Nov 04 2021 03:21 AM
SolutionEasiest would be to move the Amount column to right of the months. Select both the months and the amounts. Insert and select chart type.
Otherwise:
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).