Quickly create a dynamic polyline chart with scroll bar in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
A dynamic polyline chart with scroll bar highlights a specific data point in a two-dimensional dataset by scrolling the scroll bar and selecting an item in the list as shown below. To create a dynamic line chart, you can use Kutools for Excel’s Dynamic Polyline Chart feature, which enables you to get this job done with few clicks.
To quickly create a dynamic polyline chart with scroll bar, please do as follows:
Step 1: Click Kutools > Charts > Category Comparison > Dynamic Polyline Chart
Step 2: Select data in the pop-up Dynamic Polyline Chart dialog box
- Series Values: Select all the data points from the source range except for axes (row headers and column headers).
- Series Names: Select the vertical axis (y axis).
- Axis Labels Range: Select the horizontal axis (x axis).
Step 3: Click OK to get the result
A dynamic line chart is created instantly once you clicked OK. Now you can move the scroll bar to see the data point on a different horizontal axis, or select a different item from the list to see data of the corresponding item.
- Instead of selecting the data by yourself, you can select the whole table first, and then click on the Dynamic Polyline Chart feature. So that the corresponding range boxes will be filled automatically.
- The numbers of rows in the Series Values range must be equal to the number of cells in the Axis Label Range; The number of columns in the Series Values range must be equal to the number of cells in the Series Names range.
- The feature supports undo (Ctrl + Z).
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.
