Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to skip cells in column for charting
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?" |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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?" |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to skip cells in column for charting
Hi,
You could use autofilter on the range and only display those marked as Price. With the chart selected use Tools Options Chart, to check the Plot visible cells only is checked. And if your chart is located above the rows you might want the set the Don't move and size with cells option. Right click chart area and use the properties tab of the format dialog. Cheers Andy Ruggiero wrote: 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?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
Skip column cells and copy formulas | Excel Discussion (Misc queries) | |||
I sort a column, how can I have all the data skip every other row | Excel Worksheet Functions | |||
How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Average Column, but Skip Null and 0? | Excel Worksheet Functions |