Appologies - This post got posted twice in error
I have a data set which records earnings on a monthly basis and compares these to target figures. I need to be able to dispaly this information in a line graph (see attached). The problem I have is that for future earnings, i.e. March to December in the sample, the figures are not yet known, resulting in the line dipping back to zero.
I don't want to have to edit the data set each month to add the latest month, so I want to know if there is any way to specify that the line only displays the months for which there is data i.e. anything greater than zero, so in my sample it displays all 12 months for the target line but only Jan and Feb for the earnings line.
Then each month when the earnings figure is entered, the chart extends the line to include just that months data and so on. so you don't get the line dipping back to zero?
This isn't an issue with a bar chart, but I need a line chart.
Many thanks
Bookmarks