#1
|
|||
|
|||
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic chart ranges | GlowingApple | Excel | 1 | 02-17-2016 07:18 PM |
Generating a chart with dynamic series | Officer_Bierschnitt | Excel | 3 | 10-15-2015 12:30 AM |
Dynamic Chart with Non Continuous data | swati_04 | Excel | 0 | 03-02-2015 12:06 AM |
Changing the color of the last column in a chart changes the legend | met0813 | PowerPoint | 0 | 01-03-2014 09:02 AM |
Need more space between chart legend and border | SteveBump | Excel | 1 | 12-10-2013 02:50 PM |