Dynamic chart range remove blank legend

[Dhamo]

Hi


I have a chart in a sheet and data in other sheet. The data range may vary then and there.

Data: B2 to Q3 (sheetname: Test Execution Data)

chart name: Chart 1 (sheetname: Dashboard)

Problem: If I have no data in column Q, then the legend color should not be shown in chart. But it is showing currently. And when column R is updated with data then the chart should be updated with that data as well.

Can any of you please solve my problem?

 

[Dhamo]

Sample file:

http://www.2shared.com/file/DsLx5t39/Dynamic_Chart.html

 

[NARAYANK991]

Hi ,


You need to create two dynamic named ranges in Dhamo's file , as follows :


Chart_Series referring to : ='Test Execution Data'!$B$3:INDEX('Test Execution Data'!$3:$3,COUNTA('Test Execution Data'!$3:$3)+1)


Horizontal_Axis referring to : ='Test Execution Data'!$B$2:INDEX('Test Execution Data'!$2:$2,COUNTA('Test Execution Data'!$2:$2))


Use these two ranges in your chart.


Narayan