Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i add a scroll bar to a line chart?
Im trying to put a scroll bar on a line chart in excel 2007 using 3 lines of
horizontal data from another worksheet, the top line is the period labels(p1,p2,p3 etc) the other 2 lines underneath are performance figures and the target amount, i want to display any 12 periods of 24 depending on where i set the scroller, i know its the OFFSET functon but im having trouble figuring out how to name the ranges etc i can't seem to get the scroller to work. I could do with step by step instructions!! Any help would be really greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Line Width in Line or Scatter Chart | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Chart Type - Line Column adding a 2nd line | 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) | |||
Vertical scroll bar jumps scrolls line 1 to line 2705? | Excel Worksheet Functions |