Data doesn't show in chart

[irontis]

Hi guys,

Let's start saying that my Excel knowledge is very basic and when it comes to charts is less than zero. However, I am trying to find how to work with it through tutorials as I need it for a urgent project.

Using data from a report I have, I am trying to pull a basic column graph that shows two values in comparison. Although, once I generate the graph from the data, there's no column appearing even if the data seems selected correctly. Please see screen below:

I have literally watched 7 different tutorials, and they all do the same thing to pull up a basic graph. Mine always comes blank for some reason and I don't seem to get the columns, lines or whatever even if I change the style of graph. Maybe it's something really easy, I just can't seem to find the problem.

Thanks in advance for your time, and I hope you can help me

 

[6StringJazzer]

Please copy from A3:E12 and paste the data directly into your post. That will allow us to paste it into an Excel sheet and create a graph. Few people will take the time to type it all in from a screen shot. It's hard to diagnose what's wrong without being able to see the details of how your chart is built, but we can probably explain how to build what you want.

 

[irontis]

Sorry for that, I didn't think of it, actually. Is it okay like this, or should I use the mini-sheet function?


Ranker

Rank position	Property	ITR	Elite
1	Rome (ROMWV)	84.6	71.4
2	Doha (DOHWH)	78.2	79.4
3	Amman (AMMWI)	76.4	80.0
4	Ibiza (IBZWH)	73.8	64.1
5	Muscat (MCTWH)	73.2	61.9
6	Verbier (GVAWH)	71.2	73.9
7	Abu Dhabi - Yas Island (AUHWH)	69.6	69.9
8	Istanbul (ISTWH)	69.2	75.0
9	Amsterdam (AMSWH)	68.8	71.8
10	London (LONHW)	68.3	71.8
11	Dubai - The Palm (DXBTP)	64.5	60.3
12	Barcelona (BCNWH)	61.8	55.8

 

[6StringJazzer]

I select the data, go to Insert > Recommended Charts > Column Chart and BINGO I get a chart. Specifically what steps are you taking?

Edit: I just noticed you have hidden column C. That may be part of the problem, depending on how you selected your data for the chart. I pasted the data like you presented it, in four adjacent columns.

Chart for irontis.xlsx

Shared with Dropbox

www.dropbox.com

 

[irontis]

I am literally following the same steps you mentioned, Insert > Recommended Charts > Column Chart. But it still appears blank or only select portion of the data, which if I then try to amend manually from the filters doesn't work and the graph blanks out completely.

I thought it was the hidden column, but I literally opened a new sheet and pasted the same data I gave you above and the same thing happen. Could I be very lucky and having a corrupted version of excel?

The chart you attached for me works and I see it perfectly, and I can also change and move the data within. So I really don't understand

I have attached the file I am originally trying to edit and where I took the data from. Maybe you can spot what's the issue from there?

Propertyranker.xls

Shared with Dropbox

www.dropbox.com

 

[6StringJazzer]

The file doesn't open. Excel says the format doesn't match the extension or there is a corruption. I highly recommend you use only the .xlsx format rather than the obsolete .xls format.

 

[Jon Peltier]

I suspect the data is not numeric but numbers stored as text, since the apparent number format in the cells is 0.0 but in the chart is 0,0. Text will plot as zero values, despite the appearance of numbers.

To fix this, copy a blank cell, select the data range, and use Paste Special, Values, Operation: Add.

To avoid this problem in the future, don't center align everything, instead use the general setting for horizontal alignment. This aligns text (including numbers stored as text) to the left and numbers to the right. This is a very effective visual cue about the data. Also, don't disable error checking, so errors, including numbers stored as text will be flagged with a small green tringle in the top of the cells.

 

[irontis]

Thanks for the heads-up, I will keep it in mind for the future.

However, I checked and the data in all the cells is stored as numbers and not text. Or at least that what it seems like.

I also had a colleague of mine to download the same report from our work platform, and he managed straight away to generate the graph from the same file. So I am not really sure still why I can't manage to succeed in such an easy task.

 

[irontis]

Also, I am attaching again the report as I am downloading it from my work cloud. @6StringJazzer sorry it is downloading automatically in .xls from the website. I resaved it in .xlsx, and hopefully you can now open it correctly

Propertyranker YTD.xls.xlsx

Shared with Dropbox

www.dropbox.com

 

[Alex Blakenburg]

You might want to get your colleague to show you what he is doing differently when he downloads it because in your file the figures as text.

Propertyranker YTD.xls.xlsx
	A	B	C	D	E	F
3	Rank position	Property	Intent to Recommend (Property)	Elite Appreciation	IsText C	IsText D
4	1	W Rome (ROMWV)	83.9	77.4	TRUE	TRUE
5	2	W Algarve (FAOWH)	77.8	75.0	TRUE	TRUE
6	3	W Istanbul (ISTWH)	76.2	81.9	TRUE	TRUE
7	4	W Muscat (MCTWH)	75.4	69.5	TRUE	TRUE
8	5	W Doha (DOHWH)	74.9	78.1	TRUE	TRUE
9	6	W Dubai - The Palm (DXBTP)	74.2	72.9	TRUE	TRUE
10	7	W Amman (AMMWI)	72.6	73.9	TRUE	TRUE
11	8	W Verbier (GVAWH)	69.9	50.7	TRUE	TRUE
12	9	W Abu Dhabi - Yas Island (AUHWH)	69.7	64.6	TRUE	TRUE
13	10	W Ibiza (IBZWH)	68.1	68.4	TRUE	TRUE
14	11	W Dubai – Mina Seyahi (DXBMW)	67.4	63.6	TRUE	TRUE
15	12	W Barcelona (BCNWH)	63.3	54.3	TRUE	TRUE
16	13	W London (LONHW)	62.9	68.6	TRUE	TRUE
17	14	W Amsterdam (AMSWH)	48.2	62.6	TRUE	TRUE
Propertyranker YTD

Cell Formulas
Range	Formula
E4:F17	E4	=ISTEXT(C4)