Skip to main content

Quickly create a dynamic scrollable line chart in Excel

Author: Xiaoyang Last Modified: 2024-11-19

Kutools for Excel

Boosts Excel With 300+
Powerful Features

If you have a large data set needed to be displayed in one chart, you will find that the chart data is compressed. To see the whole data, you will need to drag the chart as wide as enough. To avoid the chart taking up your entire screen real estate, you can add a scrollbar into the chart. When dragging the scrollbar, you could view the data’s changing continuously as below demo shown.

It may be troublesome for most of us to create this type of chart, but, if you have Kutools for Excel, with its amazing Scrollable Line Chart feature, you can create a dynamic scrolling line chart with only several clicks.

Quickly create a dynamic scrollable line chart in Excel


Quickly create a dynamic scrollable line chart in Excel

To create a dynamic scrolling line chart, please do with the following steps:

1. Click Kutools > Charts > Data Distribution > Scrollable Line Chart, see screenshot:

shot-scrollable-line-chart-2

2. In the popped out Scrollable Line Chart dialog box, please do the following operations:

  • Select the axis labels and series values separately under the Select Data box;
  • Specify the number of series points to be displayed in the chart from the Show series points box.

shot-scrollable-line-chart-3

Tips: You can also select the data range firstly, and then click Kutools > Charts > Data Distribution > Scrollable Line Chart to enable this feature, and the selected data will be filled into the corresponding textboxes automatically.

3. After finishing the settings, please click Ok button, a dynamic scrolling line chart will be inserted into the worksheet at once. When you click the scroll bar, the data will be changed dynamically as below demo shown:


Notes:

1. When applying this feature, a prompt box will pop out to remind you that a hidden sheet (named Kutools_Chart) will be created to store some intermediate data. Please don’t delete this hidden sheet, otherwise, the chart will be displayed incorrectly.

shot-scrollable-line-chart-4

2. Click the Example button in the Scrollable Line Chart dialog box, a new workbook with the sample data and sample Scrollable Line Chart will be generated.


Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
✅ Trusted by 500,000+ users and 80,000+ businesses worldwide
🚀 Compatible with all modern Excel versions
🎁 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon