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
+----------------------------------------------------------------
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
+----------------------------------------------------------------