Hi I am trying to plot a composite chart where in I have 3 layers of steparea chart to be plotted.
On the X axis I have time in hh:mm format and on both Y axis there is some numeric data to be plotted. In the attachment, I have provided the source code that I am using currently to plot the chart and also in an excel sheet I have provided the data and sample chart output.
However, I need your help to sort out on issue. As I mentioned earlier, on the X-asix I have time plotted in hh:mm format. In the data, the time is not continuous i.e the time duration from 11:00 am to 12:00 noon is missing (as per the requirements), but still on the chart I get to see the data points during this time. Is there a way to exclude this time range? Or rather is there a way to plot only the time values those are available in the data source.
Kindly help me to sort out this problem at the earliest.
Regards
Reena
so if i understand correctly, you want to change the way the blue area or "buy qty ratio" displays from 10:59 to 12:00.
but i don't understand what you want to see in its place. if you want the line to go back down to zero, then you would have to add a datapoint with value = 0 at 11:00.