Line Graph with variable X-Axis

[Graham White]

Hi,

I want to create a line graph where the end point of each line in the series ends at a different point.  E.g. A graph showing a line for sales YTD and Budget for the year.  The Sales line will only show January figures for first month but the budget will show the whole 12.  I want the Sales line to just stop at January and not drop down to 0 for the other 11 months.  How do I format this in the row logic?

Regards

Graham

[Louis Gale]

The charts will not render a data point when no value is provided - i.e. null value.  This will prevent the line from 'dropping' to 0.  So in your case, for the Sales series provide a value for January and null (nothing) for the other months.  There are many posts addressing this, see here for example.