EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Interactive Chart in Excel
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Interactive Chart in Excel

By Soumyashree DasSoumyashree Das

Interactive chart in excel

Excel Interactive Chart ( Table of Contents)

  • Introduction to Interactive Chart in Excel
  • How to Build an Interactive Chart in Excel?

Introduction to Interactive Chart in Excel

Visualizations in graphical form tell the story better than any other form. But an interactive chart is even better. The interactive chart makes visualization better and user-friendly. When a user clicks on a value, then the result is shown. For example, if the chart is showing “Sales” on the chart and a user wants to see the “Profit”, then by clicking on the “Profit” shows the “Profit” chart accordingly. In this way, the interactive chart works. Charts can be filled with different colors for eye-catching. Every organization needs this chart, and a data analyst works on such charts to make it more interactive and visually friendly. This type of chart is mostly used in finance models where a business needs to understand its loss and profits. This type of chart can be plotted in many visualization software, including MS Excel. Charts in Excel is comparatively easier.

Methods to Build an Interactive Chart

Let’s discuss some methods of building an Interactive chart in excel.

Method #1

  • Plotting a chart needs tabular data. Data is mostly vertically by default. We can convert it into a horizontal form, as shown below. Below is the table.

Interactive Chart in Excel 1-1

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Interactive Chart in Excel 1-2

  • The table can be copied and pasted in transpose form, as shown below.

Interactive Chart in Excel 1-4

The data is in horizontal form now. Below the same, we can create a similar template with sales values as blank.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,596 ratings)

Interactive Chart in Excel 1-5

  • Now, we can insert a scrollbar by going to Developer options >

insert -developer

We’ll have to draw the scrollbar in this way.

developer scrollbar

  • The next step is to right-click on the scrollbar and select “Format options”, as shown below.

format control

Then we’ll have to choose “Control”, and the window will come up then.

format control 1

  • The “Maximum value” to be set at 12 as we have 12 months in the table. Leave the “Current and Minimum value” as it is as 0. “Increment change” should remain 1 as when we click, it should change by 1. Next, the “Page change” should be set to 0. Cell Link is A9 is for us. After all, is set, we can press “Ok”.

format control 2

  • The scrollbar is ready now. When we click the forward button number of times, it will increase by the same number of times, and the result can be seen on cell A9, as shown below.

format control 3

Similarly, if we press the backward button, we can see that it reduces by 1, and the result is seen in cell A9 accordingly.

format control 4

  • Now in cell B5, we can apply the formula as shown below.

if formula

The formula is saying that the A9 value increases or decreases by 1 when we click on the scrollbar. So, we’ll have a value from cell B2 or else it will show an error as “#N/A”. The first month is January, so it is written as “>=1”. Similarly, for February, the cell value will be C2, and the condition will be $A$9>=2, and the rest will be the same. In this way, all the month’s sales value can be entered. For convenience, we can drag the cursor till the last month to get the values as well.

  • Now, we can plot a column chart for the table. We’ll first select the table and then go to Insert > Column chart as shown below.

insert -developer 1

The column chart is ready, as shown below.

sales chart

  • We’ll now select the points and do a right-click and go to “Format data series”, as shown below.

format Data Series-1

Now we have to go “Fill” and then select “Vary colors by point”.

format data series-2

Finally, the chart is a colorful one now.

sales chart 1

  • Now when we scroll the scrollbar, the value and chart will change, as shown just below.

sales chart 2

If we want the data for 7 months, it will show as above. For convenience, we can hide the original table, i.e. the first two rows. This is one of the methods for interactive charts.

Method #2

  • This is another way to pot an interactive chart. Let us suppose we have region-wise sales data as shown below.

Interactive Chart in Excel 2-1

  • Now we can simply create a drop-down list for the same by going into developer options as we applied for the scrollbar above.

Interactive Chart in Excel 2-2

  • Now we can create a duplicate table without numbers just below the drop-down list.

Interactive Chart in Excel 2-3

  • Now, we can apply the formula on cell B10 as shown below. East has been selected in the drop-down. So the formula says $A$7=A10.

Interactive Chart in Excel 2-4

The result is now shown below.

Interactive Chart in Excel 2-5

In this way, we can enter all the regional sales in the table.

regional sales

As we have selected the “East” region from the drop-down menu, it shows the “East” region only.

  • For this chart, we can create a line chart by going to Insert > Line & Area chart and select the first chart.

insert-if

Now, the chart is created as shown below.

Interactive Chart 2

This chart is showing only the “East” region’s data because we have selected “East” from the drop-down menu.

  • Similarly, if we select “North” from the drop-down menu, the sales amount of the “North” region will be shown in the chart as shown below.

Interactive Chart 2-1

These are a few ways in which we can plot interactive charts. There are other ways too to plot the same.

Things to Remember

  • Advance Excel skills are pre-requisite.
  • Data restructuring and form controls are needed for interactive charts.
  • We can make use of pivots and slicers for interactive charts as well.

Recommended Articles

This is a guide to Interactive Chart in Excel. Here we discuss How to create Interactive Chart in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Comparison Chart in Excel
  2. Marimekko Chart Excel
  3. Grouped Bar Chart
  4. Bullet Chart in Excel
Popular Course in this category
Free Online Excel Course
3+ Hours | Lifetime Access | Verifiable Certificates
4.5
Price

View Course

Related Courses

Excel Advanced Training (16 Courses, 23+ Projects)4.9
Excel Data Analysis Training (17 Courses, 8+ Projects)4.8
Excel for Marketing Training (8 Courses, 13+ Projects)4.7
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formulas, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more