Chart series display problem

  • Thread starter Thread starter John Ross
  • Start date Start date
J

John Ross

At the end of my chart I always have a vertical line that is going to 0.
That is caused because the cells that the chart draw contains formulas. The
outcome of the formulas is space but the chart sees them as zeroes.
What I would like to do is the use somthing like the formula below using the
indirect function inside a series function so I can always know which is my
last cell to draw that contains information:

=SERIES(Investment!$G$2,Investment!$B$31:$C$181,Investment!$M$31:INDIRECT(CELL("address",A162)),1)

Unfortunatelly it is not acceptible by Excel.

What can I use instead????

Tx
JR
 
Hi,

Use NA() instead of "" in your formula. Use conditional formatting, if
necessary, to mask the #N/A's

Cheers
Andy
 
Back
Top