Hi all,
Please see attached picture and workbook.
Chart.png
I have some source data that I'd like to display graphically. This is price data where one row represents one day. Each day starts at 09:30 and ends at 16:00 where the two swing points in between vary. I run into two problems:
1. Ideally, I'd like to use the "source data" to create charts directly, but I haven't been able to do so. Maybe it can be set up differently to accomplish this. Ideally, it would be one row per each day.
To create the associated charts, I've manually set up my data as can be seen to the far left. I don't know how I'd proceed doing this for an entire set of data.
2. Regardless of when the price points (Point 1 Time & Point 2 Time) are recorded, they are each given the same weight/length. This is shown very clearly on the both the first and last day where the swing point 2 is almost at 16:00, yet it's just as lengthy as the first swing of the day.
Using a scatter diagram seems like it might solve this actually. At least it's a big improvement.
But the scale isn't right...Id like it to always start/end at 09:30/16:00.
Any advice on how to proceed with this?
Thanks in advance!
Bookmarks