View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?"