how do i add a scroll bar to a line chart?

J

jackrobyn1

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.
 
J

John Mansfield

If you go to my site and send me an email with an example of your data, I'll
attempt to put together an example and send it back to you.
 
J

jackrobyn1

thats done the trick ive managed it after a bit of messing as im a bit of a
beginner, thanks very very much for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a scrolling line chart? 0
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
how to add error bars into bar chart 0
How do I add a horizonal target/goal line to a line chart? 2
how do I add a goal line for a bar chart? 1
How do I show a data table with legend keys in a line chart? 1
How to insert a "Target" line into basic bar chart 1
How do I create a chart with 6 bars for data and 1 total line 2

Top