![]() |
|
#1
|
|||
|
|||
|
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 |