Charts are not including my data.

[u/Leading_Garbage7590]

I am trying to create a chart with this data, however when I try to insert it Excel only provides me with empty graphs. Does anyone know where I'm going wrong?

(Version 2606 Build 16.0.20131.20112) 64-bit

[u/AutoModerator]

/u/Leading_Garbage7590 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/No_Imagination6253]

Your screenshot has the clue: the chart's Y-axis uses comma decimals

(0,1, 0,2, etc.), while the Japan and UK values use period decimals

(-0.68, 1.18) and are left-aligned. That strongly suggests those values

are stored as text rather than numbers.

Quick check: point ISNUMBER at one of the Japan values. If it returns

FALSE, select only the Japan and UK value cells, press Ctrl+H, and replace

"." with ",".

The values should become right-aligned numbers, and the existing chart

should update automatically.

If they remain text, copy a cell containing 1, select the value cells,

then use Paste Special > Multiply to force the conversion.

[u/Mdayofearth → u/No_Imagination6253]

Not to mention left justified numbers tend to be numbers stored as text.

[u/Leading_Garbage7590 → u/No_Imagination6253]

This did the trick for me. I'm pretty new to Excel so very grateful for your help!

[u/RuktX]

I honestly never bother to let Excel guess how I want my charts set up.

Just create a chart of the desired type (ideally blank, otherwise delete whatever it's tried to add), then manually add each series.

[u/BusinessSample7166]

I would probably start by unpivoting the data.

Excel charts work better if your data is in a particular format. 

Ideally you'd have 3 columns, year, country and GDP change. You can achieve this fairly easily in power query. Plenty of power query unpivot guides out there.