How to skip cells in column for charting
You could create a dependent table where you put the headings, and where the
row says price, use that value, otherwise add a formula of NA(), such as
=IF($B2="price",C2,NA())
and then chart that table.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Ruggiero" wrote in message
...
I have made a handy stock info table. Each stock has its own column
(columns
3-10). Most rows show just share prices for the stocks held, but some
show
numbers of shares or total invested in the stock. The rows of share
prices
are marked in column 2 as "price." Is there a way of not charting the
rows
not marked as "price?"
|