Business Intelligence  10 steps to creating a scrolling Excel
chart  When you have too many data points to display in a
dashboard chart, add a scroll bar so users can still view all
the data.  Sometimes a chart's underlying data doesn't fit in
the chart window. When this happens, Excel tries to accommodate
by shaving off a few values. You can make the chart bigger, but
that won't always be feasible, especially in a dashboard sheet.
Besides, you might have more points than even a large window can
display. When this is the case, you can add a scroll bar that
lets the user scroll through the data. While I've seen some
complex techniques for employing this solution, my technique
requires just 10 quick and easy steps.  Note: In step 10, I
insert a column to center the dashboard components. Doing so
changes many of the referenced cells and ranges throughout the
first nine steps. If you're working with the downloadable demo,
don't let those differences confuse you -- they'll all be off by
one column.  1: Determine y