I have a chart which is created using named ranges to make it dynamic and it works well as it doesnt show data for entries that have the data supressed. However, for lines where the data is hidden (as it is a zero) it still shows their lines up in the Chart Legend but with no label against them (as it has been suppressed as a "") and no data lines. Is there any way to stop these from showing up on the graphs.
The chart is dependant on a drop down selection and therefore the number of data lines in the chart changes between one and 9.
Thank you for any assistance you may be able to offer with this.
Refer the following thread and check if it helps to resolve the issue: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/chart-named-range-not-dynamic/90619c45-96b3-484b-996c-ea12485d3462
Note: It is recommended that you back up your files and folders before attempting this step:
Move the mouse cursor over to the upper right side of the screen.
A menu will pop up on the left. Click on the "Settings" feature on the menu.
On the Settings window, click on the "Change PC settings."
Now, left click on the "Update and recovery" feature.
For the next step, left click on the "Recovery" feature.
There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
Now, follow the instructions on the screen to finish the Refresh process.
After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
Check again to see if the error Dynamic Chart Legend has been fixed.