Forum Discussion
zainab_alsaeed
Nov 04, 2021Copper Contributor
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 ???
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 ???
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
- Riny_van_EekelenPlatinum Contributor
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.
- zainab_alsaeedCopper Contributori highlight data,but that does not work
- Riny_van_EekelenPlatinum Contributor
zainab_alsaeed Difficult to help if you don't share your file.