Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
exclude certain data
Hi
I have a series of data in rows which are plotted on a simple line chart. Sometimes I want to exclude a particular data row from appearing on the chart by typing X in a column (I currently use this to exclude that row of data from average & mean calculations, which I also plot on the same chart) Also, I have upto 30 rows of data printed on one chart - is it possible to scroll the the dataset & highlight the chart line that the data belongs to. I do not have labels because it makes the charts too crowded I'm sure I've seen this somewhere but can't find it again Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I exclude a value in data validation? | Excel Discussion (Misc queries) | |||
How to exclude data that has already been imported? | Excel Worksheet Functions | |||
How do I use DCount to exclude data? | Excel Worksheet Functions | |||
How to exclude data already used? | New Users to Excel | |||
Exclude more than one row from data-Sort | Excel Discussion (Misc queries) |