Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Query
Hi,
I am trying to put together a line chart of some information. The problem is that it looks quite crowded on the chart. Is there a way of having a line chart where you can select a few of the data sources to see just those lines, without having to have a different chart for each data source? My ideal situation would be where I have 18 data sources, and I can click between those 18 and see line charts for those 18 individually, or any combination of them without having to have several line charts. Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart Query
Have you tried a filter (such an an auto-filter) on the source data sheet?
If you choose an appropriate criterion for your filter, the chart will show only the data which the filter shows. -- David Biddulph "Furn16" wrote in message ... Hi, I am trying to put together a line chart of some information. The problem is that it looks quite crowded on the chart. Is there a way of having a line chart where you can select a few of the data sources to see just those lines, without having to have a different chart for each data source? My ideal situation would be where I have 18 data sources, and I can click between those 18 and see line charts for those 18 individually, or any combination of them without having to have several line charts. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
Problem adding vertical marker line to line chart | Charts and Charting in Excel | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |