| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart / Scrollbar / Offset / Autofilter
Hi,
I am having the following problem: I have a chart which refers to 2 columns and serveral rows of a table. I added a scrollbar to the chart (here I used the offset function to define the range for my series). This works fine so far. But when I use the autofilter on my datatable then I have the following problem: The filter shows line 3 and 96. My ranges I have in my autofilter are in steps of 10. It shows me now one bar (for line no 3) then I have to scroll 8 times up to I get the bar for line 96. Does anybody has some experience with this and can help me? Thanks in advance, Oliver |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| chart from Pivot chart | Charts and Charting in Excel | |||
| How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
| Can I use the autofilter feature to limit data for a pivot chart? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Is there a way to offset the y-axis of a chart without having the. | Charts and Charting in Excel | |||
Linear Mode
