Hello,
I have this chart attached. You can see that one of the data starts only from July, so the blue line goes abruptly up from 0 to the actual number. The data is linked to another table with the ‘raw data’ in it, so I can not simply delete the cells with 0 in them (as the data is moving, next month everything will be shifted to the left, so eventually everything will be populated with data).
Is there a way (formatting, etc) that the line for that particular item to start not from bottom up but directly with the very first number that is available – so we don’t have that ugly vertical line in the chart?
Thanks in adv.
K.