Forum Discussion
Zara2005
Apr 16, 2022Copper Contributor
bar graph
Hi there there is problem with my excel and it does not bring up my bar graph? and I have tried many ways but no outcome.
Zara2005
Apr 16, 2022Copper Contributor
I have my x & y values, but when I highlighted them and put them into bar graph the graph is not what I want it shows empty graph.
I have tried to switch the numbers but the number of the years appears on y axis.
Riny_van_Eekelen
Apr 16, 2022Platinum Contributor
Zara2005 You still haven't shown the data, so it will be difficult to diagnose. Obviously, you do not want an empty graph, so somethings is wrong with the data (perhaps they are texts like Subodh_Tiwari_sktneer suggested) or something else. Can you perhaps share a file to demonstrate the problem? Via OneDrive or something similar, for instance.
- Zara2005Apr 17, 2022Copper Contributor
- Riny_van_EekelenApr 17, 2022Platinum Contributor
Zara2005 I'm 99% sure that the amounts are texts. $4.9B is, very likely, not a number. Try again by getting rid of the $ sign and the B at the end.
- Zara2005Apr 17, 2022Copper Contributor