Freezing Excel Charts

[justmejudi]

Hi, I have an existing Excel chart (trendlines only shown) that I need to freeze where it currently is and add going forward live data. Is this possible?

[Cheeky Charlie]

Hi, please title your thread with something like a description of your actual question - i.e. something someone would find if they searched with the same issue. The question sounds quite interesting but I can't get involved until you play by the forum rules.

[Andy Pope]

It's not very clear from your question what you want.

What is to be frozen, the trendlines? If so then add new series with empty cells for historic data periods.

If you need more help post a workbook that is not linked to you local server