Creating chart in VBA? Chart based on user selected date?

Hi all,

I was hoping I could get some assistance on creating a fairly basic line chart. I considered posting this in the charting section, but it might be that this is better solved using VBA?

I created an additional sheet just to show a bit better what my problem is. My "raw data" is in a table in column J-O. I tried creating a chart using just this table, but it's a mess.

In cells C3&4-F3&4 shows how Excel would like to read my data in order to print a line chart with paired data.

Basically, the first data point is always 0 at 09:30 and the final data point is always at 16:00 with a corresponding price (see table).

Maybe there is a smarter way to format/set up my data such that I can create charts directly from my tables?

Chart.png

Finally, I was thinking that it would be great if I could have the functionality of refreshing/drawing the chart by selecting the corresponding date. I could select the cell with date and then run the macro.

Chart2.png

Maybe this is too involved of a task to be asking here for free, but I figured I could ask.

Thanks in advance for any help!

Best regards,

Elijah

Also, there is a weakness with the chart I created since it has only 4 time points with equal distance between them.

There is 6 1/2 hours from 09:30 and 16:00.

Between the 2nd and 3rd data point, there's over 5 hours, but it appears to be the same as between the 3rd and the 4th which have only 2 minutes...

I tried solving this by writing 09:30, 09:31, 09:32, 09:33,...15:57, 15:58, 15:59, 16:00 and putting in numbers where fit (and blank cells for the rest), but Excel didn't seem to handle that when trying to create the chart.

Uten navn.png

Anyone?

I see there's a possibillity to pay for services on this forum. I could pay for this project, but I'm not sure how much such a project will cost as I need to pre-pay, I think?

Best regards.

I hope it's okay with a final bump on this one. And if nobody can help me out (for free), maybe I could get some pointers on where to get it done paid for and how much. As mentioned, I know of the possibillity to pay for services here, but don't know what it would cost and if I'm guaranteed to have someone do this if I do buy points.

Anyone?

Maybe there's other ways to accomplish this?

I'll gladly pay to get it done.

Best regards.

Elijah

Hi, humdingaling,

Thank you for your chart suggestion!

It does look like an improvement for sure. I hadn't tried the scatter plot.

I'm however a little embarrased to say that I don't quite understand how it works. What's DV?

I see that the axis changes when I adjust the DV value, although I can't seem to see how (marking all the associated data and I only have cells C-F highlighted).

Also, in case there was any confusion, for this data, I will always have the start value at 09:30 and the end time at 16:00.

But the way my line charts end up, all points/swings will have similar length regardless of when they happen during the day and this is not quite correct...

Thanks for any further advice on this matter.

Best regards.

Elijah

Thanks a lot, humdingaling.

I'll have to explore it further one day I get some better time.

Not sure which coding you refer to? The formulas...?

I still consider myself fairly basic with regards to Excel and have a LOT to learn.