Allways only show the last data label

[MetteGaga]

Hi!

I have a chart which i update every week.. I would like to make the chart show the last data label, always, also when i add more data..
But right now i have to do it manually. Is there any way to make this happen automatically?

Thanks in advance

[Andy Pope]

Use dummy series for the labelling
http://www.andypope.info/charts/Labellast.htm

[MetteGaga]

but my chart show the full year, from week 1 to 53, nut only has data to week 33.. I add new data every week..
So this week the datalabel must be at week 33 but next week 34...

so i dont se how i can use the linke.. :/ any other ideas?

[Andy Pope]

you need to post example file so we can see exactly how you have it set up currently.

[MetteGaga]

I have tried to add a test file

[Andy Pope]

some thing like this.

[MetteGaga]

thanks that i think i can use is there anyway to hide the label Y label X and label total from the Graph data overview in the chart? (the box which show what data is being shown)

[Andy Pope]

yes, select the legend then select the legend entry and delete. Repeat for other 2 series you want to remove

[MetteGaga]

thanks a lot