Graph for Times (Formatting issue?)

Hi,
I have a bit of a strange one, I hope I am in the right place?

I have some graphs that include dates and times (h):mm:ss, when I paste my data into excel it is already in this format and also the column that includes the times is is also formatted as (h):mm:ss.

When I paste the data into my feed sheet, it all pulls through correctly to the table I am using for the graphs via a look up, but the data will not appear in the graph until after I double click on the cell that contains the (h):mm:ss. Visually when I double click it moves the text from the left of the cell to the right.

So, I am hoping someone can explain this or knows a solution as it is very frustrating.

Brief overview:

Paste data into sheet1 in excel,
Data pulls through correctly to table in sheet 2 via a look up.
Graphs remain blank.
Go to table on sheet 2 and double click - data will appear in the graph for that cell, to get them all in I have to manually double click each cell.

Any help on this would be greatly appreciated.

Thanks
Tom

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

When you copy and paste, do you paste values?

Type this into any cell below the table:

=--B4:C9

It converts the tables to values (you can format the table to show these values as time if you wish).

You haven't said what the lookup is - that's probably the issue.

That's the problem - text values are not number values.

But you said there was a lookup to create the table, so I am a bit confused.

Anyway, you can use my suggestion instead of copy and paste.

For further help, provide a workbook with the whole picture (source data and INDEX MATCH).

Provide the full picture in a workbook and I shall advise. I need to see the formula at the very least.

Sounds like you could be making use of new 365 functions, actually.

Can you at least share the INDEX MATCH formula that you are using?

I'd have to see a sample of the data - sorry. It's not clear exactly what the nature of the data is.

When you have time to create a small sample subset, I'll have a look.