HomeApplicationOffice information

'Moving' chart in Excel

Do you see a motion chart in Excel?With a simple, self-created Viual Basic program, you can make your chart move to look lively.Suppose, you have a data table with column A containing the variable X (from A4: A19).

'Moving' chart in Excel Picture 1

The value of the following variable X always equals the value of the variable X before it plus the value specified in cell A1.You give the initial value of variable X to 0 (cell A4), the formula for cell A5 = A4 + $ A $ 1.Next you select a range (in this case, A5: A19) and press Ctrl + D to copy the formula from cell A5 to the remaining cells.Column B contains the function value Y = SIN (X).Then go to Insert Chart to chart the value area you created.(You should use Chart Type as XY Scatter).

'Moving' chart in Excel Picture 2

In order for your chart to move, you must write a function to change the value of cell A1.Then the value of the data sheet will change and make the chart change as well.Press Alt + F11 to display the Visual Basic Editor window.In the Visual Basic window, press F7 to bring up the Code window.Write a function like this:

Sub BieuDoDongDay ()
Range ('A1') = 0
For i = 1 to 150
Range ('A1') = Range ('A1') + 0.035
Next i
Range ('A1') = 0
End Sub

Back in Excel's window, press Alt + F8 to open the Macro window, then click Run to execute the program.You can set shortcuts for newly created functions by pressing Options.That's it, you can admire your work already.

'Moving' chart in Excel Picture 3

TRAN MINH TUNG (Tan Binh, Ho Chi Minh City) - According to Echip

4 ★ | 1 Vote
valuechartrangewindow

You should read it

May be interested

  • How to create a pie chart in ExcelHow to create a pie chart in Excel
    pie charts are a regular way to show things through data, which help your paper be scientific and attract readers. the following article details how to create a pie chart in excel.
  • How to Make a Pie Chart in ExcelHow to Make a Pie Chart in Excel
    this wikihow teaches you how to create a visual representation of your data in microsoft excel using a pie chart. open microsoft excel. it resembles a white 'e' on a green background.
  • Hide and show chart labels in ExcelHide and show chart labels in Excel
    the following article will guide you in detail how to show / hide chart labels in excel. for example, the following chart is created: 1. want to add revenue details for employees displayed on the chart do the following.
  • How to Create a Multi-Line Chart in ExcelHow to Create a Multi-Line Chart in Excel
    drawing a multi-line chart in excel is very simple! if your spreadsheet has multiple groups of data, you can view the data visually by creating a chart with multiple lines. you can create a new chart or add lines to an existing chart. this article will show you how to create a multi-line chart
  • How to draw a map chart on ExcelHow to draw a map chart on Excel
    in excel 2019, there is a map diagram, showing the names of countries in the world.
  • Create Excel charts that automatically update data with these three simple stepsCreate Excel charts that automatically update data with these three simple steps
    excel charts help shorten the decision-making process, because we can immediately see the results and things to change. however, the difficulty in processing data and charts is that users must constantly return to the chart and update new data. yes, this problem will be gone when you follow these three simple steps to create an excel chart that automatically updates data.
  • How to create a frequency chart in ExcelHow to create a frequency chart in Excel
    how to create a frequency chart in excel. with the frequency chart you can determine the frequency of occurrence of the event, the variability ... the following article gives detailed instructions on how to create frequency charts in excel.
  • How to Add a Second Y Axis to a Microsoft Excel ChartHow to Add a Second Y Axis to a Microsoft Excel Chart
    it would be helpful if you knew how to add multiple data lines to an excel chart. however, with data with many units, you may find it difficult to create the graph you need. don't worry, not only can you do it, you can do it very easily!
  • How to create 2 Excel charts on the same imageHow to create 2 Excel charts on the same image
    the combination of 2 charts on the same excel image helps users easily show the data.
  • How to create an effect for an Excel chart in PowerPointHow to create an effect for an Excel chart in PowerPoint
    excel makes it easy to aggregate multiple streams of data and convert them into easy-to-understand visual charts. when you pair your data with powerpoint, you can create excel chart effects to make presentations more attractive.

Office information