View Single Post
 
Old 08-25-2016, 04:46 PM
Toonook Toonook is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Aug 2016
Posts: 1
Toonook is on a distinguished road
Default Fixing legend of a dynamic chart

Hi all, long time lurker first time poster. Creating a dynamic chart via form controls to allow users to compare any specific combination of data they want quickly. Data is 3 options for 13 sites, so 39 possible options. The chart is working well, but the problem I'm having is the legend! It's beyond me. All 39 options are listed, I just want the legend to show what check boxes are currently picked, thus what is currently shown on the graph. Should I spend the time to do a data label for each lines last point? Is there an easier way?
Reply With Quote