Everytime I press a button it will update the 30 charts with data from 30 worksheets (there are 33 buttons so a lot of code). The "Trending Charts" sheet holds all the charts. Each chart shows the last 15 entries on each sheet so if there have been any new entries the points on the chart wil shuffle down/along or what ever you want to call it. I created the charts by running "record macro" 30 times and the charts themselves work fine.
When I wanted to add limit lines I needed (as told by someone else on here) to create a news series which I did, and it worked, until I ran it 255 times. I have now removed the create new series line and it works so long as I don't remove the series from the Series Data source window.
If this forum didn't spit the dummy everytime I tried to post the code then I would. I will try and upload one buttons worth in a text file.
The first 2 charts have 2 limit lines
and
all the others only have
PS. I never said I didn't want to change the code I was just after solutions to the problem.
Bookmarks