Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
420
Composite chart - Step area chart help
posted

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

 

Chart_Query.zip
Parents
  • 28496
    Offline posted

    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.

Reply Children