Cell reference data not displaying in chart

  • Thread starter Thread starter horqua
  • Start date Start date
H

horqua

I use a chart where a certain datapoint has to be entered twice. I'
like to change it to enter the data once and have the data appear i
the referenced cell and as part of a simple bar chart. Here are th
particulars: In cell B27 I enter the datapoint for the first tim
(58.7). Currently, I have to enter that same datapoint in cell F24
That same datapoint is part of a three cell source for a simple ba
chart. When I try to use a cell reference, the bar is flat depicting n
data. Here's what I mean; If I put the data (58.7) into cell B27, an
put the datapoint reference in cell F24 (=B27), then, the bar (whos
source is F24) goes flat. I have tried to re-source the cell referenc
to B27, but I receive the same results, a flat bar. So, my question is
can the cell reference in F24(=B27) be formatted so the chart wil
recognize the referenced data (58.7) rather than the cell referenc
(=B24) and make the bar extend rather than showing 0 (flat)

+----------------------------------------------------------------
| Attachment filename: ldad 3 charts.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=355444
+----------------------------------------------------------------
 
After you enter your formula into F24 and press Enter, what appears in
that cell?

- Jon
 
Back
Top