Complex Chart With Dummy Axis Labels

**John Vieren** · 03-12-2009, 04:16 AM

Dear All,

Please find enclosed 2 charts.

They have dummy axis labels.

The first chart does not show the last 2 values on the axis?

The second chart uses the Chart 1 axis labels, instead of second chart labels?

Please can anyone give me instructions on how to fix.

Thanks for your help, regards JV

**Andy Pope** · 03-12-2009, 08:03 AM

If you link data labels to cells and then extend the range of the data series the new labels will not automatically extend the linked reference, instead they will revert to displaying automatic information.

**John Vieren** · 03-13-2009, 10:46 AM

Originally Posted by Andy Pope

If you link data labels to cells and then extend the range of the data series the new labels will not automatically extend the linked reference, instead they will revert to displaying automatic information.

Sorry but i dont know what you mean and still can not solve my problem.

Can you explain further?

Thanks JV

**Andy Pope** · 03-13-2009, 12:52 PM

If you select the data labels, then click on an individual data label you will see they are linked to cells.

How did you link the data labels to the cells? Manually or using a addin.

Anyway regardless of how you did it the last to are not linked to cells and are therefore just show the default value for that point, which is "-".
In order to show the required value you will need to link the data label to the cell.