Line Chart with Partial Data

[bdam]

I have a chart that lists the sales by months. There is a data set for the current and last 3 years. I am accomplishing this with calculation fields that create a delimited set of data.

The current year's data obviously isn't complete so the graph just nose dives to zero for future months. Is there a way to have the current year's line be partial and not plot future months? The sales guys always jump a little inside when they see that initially.

[comment]

This part is not clear:

I am accomplishing this with calculation fields that create a delimited set of data.

[bdam]

The chart type is Current Record (Delimited Data). I have four calculation fields that create this delimited data, 12 values in each that correspond to the months of the year. I then add these fields to the Y axis.

So the field that creates data for the current year won't have 12 values and I'm trying to figure out how to make that a partial line instead of a line that bottoms out at zero. If I only state 9 data points it still maps the remaining ones to zero to fill out the line.

[comment]

How many years (lines) are you showing at once?

[bdam]

All four.

[comment]

I am afraid I still don't understand the issue here. Does this work for you?

PartialChart.zip

[bdam]

Actually, you understood the problem perfectly, and solved it at the same time.

To see what I mean, in your example change the chart style to curve fitting. You'll see that your partial line takes a nose dive to zero.

[comment]

Ah. Never thought of using curve fitting. Now I see what you meant. Interesting buglet.

[bdam]

I'll send a bug report. I hope you don't mind me using your example file to create a screen shot to better describe the problem.

[comment]

Not at all.