Create a graph with date and prices. HELP! URGENT!

[#1]

Hi guys! I'm finishing my Master project in Business Intelligence, and I need a help from you, the most expert people.

I need to do a graph, who shows the prices for each hour, but the thing is, i don't need 365 lines (each day of a year) in the graph.

I want to pick a date from a calendar that I already do in QV, and this date works as input of what prices are gonna be shown on the graph.

HELP!

I attached an excel spreatsheet, extracted from the DDBB.

Hope you can help me!

Thanks in advance.

[#2]

Hi

I suggest to use crosstable function to transform your data

After you will  keep only 3 fields : Date,  Hour,  Value
Then it will be very easy to select a date and display the chart.

Look at the attachment

JJ