Can someone please tell me how to remove this annoying random text on my chart? It appears just above my data table. Please see attachment.
Can someone please tell me how to remove this annoying random text on my chart? It appears just above my data table. Please see attachment.
doesn't say total? expand the cell
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
No matter how I re-size the chart the text does not display. Usually the number "1" displays here, but even then I have always thought this was useless. Any other suggestions?
-Grave
post the chart in a workbook
Here it is...... Thanks in advance!
-Grave
its the x axis label if you look at source data on series tab youll see
={"otal"}
change that to
=""
it will change to={""} on its own
if you just leave it blank it will put 1 in
Last edited by martindwilson; 09-21-2009 at 09:38 AM.
hahaha..... Sometimes you just need a second set of eyes on something. Thanks!!
-Grave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks