Labeling an unused Chart

[ChemistB]

I recently came across a spreadsheet where an embedded line graph ha
"Not Used" in large fonts in the center of the chart area. In the wor
area of that spreadsheet was a dropdown box (created through th
validation function, not through forms) in which the choices wer
"Done" and "Not Done" If "Not Done" was entered here, "Not Used
appeared in a cell (by means of an if statement in that cell) o
another spreadsheet in that workbook. If I typed something else i
that cell, (i.e. "test") that word would appear in the chart. Th
auditing tool shows no dependents from that cell. How are they gettin
"Not Used" to appear in the chart? There are no macros or VBA module
in the workbook that I can find. The original drop down box does no
have any dependents leading directly to the chart and I can find n
formatting within the chart to explain this. Does anyone have
solution here.

Thank

 

[Andy Pope]

Hi ChemistB ,

At a guess, either one the charts titles (title/xaxis/yaxis) or a data
label is linked to a cell.

Try selecting the text within the chart and see if there is a cell
reference in the formula bar.

Cheers
Andy

 

[ChemistB]

I did check on the various labels and none of them reference any othe
cell. I cannot select the actual "Not Used" text from the chart t
investigate further. Another possible hint; if I select the plot are
of the graph and move it around within the chart area (ie slightly lef
or slightly up), the "Not Used" does not move with the chart area bu
will instead be slightly lower or higher within the plot area.

Thanks again.

Chemist

 

[Andy Pope]

Hi,

If you want you can privately email me the workbook and I will see if I
can discover whats going on.

Cheers
Andy

 

[Andy Pope]

After ChemistB sent me an example I was able to determine the
information was stored within an embedded textbox.

A useful tip when trying to select elements within a chart is to use the
cursor keys to cycle through. UP/DOWN for the main items and LEFT/RIGHT
for sub items.

Cheers
Andy

Hi,

If you want you can privately email me the workbook and I will see if I
can discover whats going on.

Cheers
Andy