Forum Discussion

zainab_alsaeed's avatar
zainab_alsaeed
Copper Contributor
Nov 04, 2021
Solved

Problem on chart

hi everybody,
I am on excel 1019 , i am try to insert column chart, after i chocie data and go to insert ribbion and choice chart ...the chart appear whithout columns !!! why ???
  • zainab_alsaeed 

    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.

     

    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).

8 Replies

Resources