When you want to compare two variables by using Excel charts, if those two variable have same measuring index then we can plot them in one charts. However, if those variables has different measurements, like one being money amount and one being quantity, then we need to use combo box which enables us to have two different measurement units in one chart.
Tag: visuals data
Basic of Charts in Microsoft Excel
In this video we talk about how can make a chart in Excel and what are the main properties of charts in Excel. Creating a chart is one of the main tools for data analyzing and Excel simple and beautiful charts are one its most well known advantages of this software