Forum Discussion
Solved
Creating an intraday chart with specific trading hours
Hihi,
I am trying to create a simple line-chart to display prices during trading hours, which in this case are 9:30pm to 4:10am, for the past 5 days.
However , the chart will show the hours where there are no prices as a line. Is there a work around this? I just want to display the speicifc hours.
Thanks!!!
The simplest way would be to split your DateTime column into separate Date and Time columns (a good practice anyway), and use the Date in the Small Multiples field.
Pat
2 Replies
- mahoneypat
Microsoft Employee
The simplest way would be to split your DateTime column into separate Date and Time columns (a good practice anyway), and use the Date in the Small Multiples field.
Pat
Thank you Pat, this is awesome! 😊
