![]() ![]() You can see that a revenue number are in thousands and are way higher than the profit margin numbers (which is in %). But with combination charts, you can have two Y-axis, which allows you to have two different type of data points in the same chart.įor example, you may be interested in plotting the annual revenue numbers of a company, and at the same time, also be able to show how the profit margin has changed.Ī combination chart (as shown below) is a good way of doing this in Excel. When you create a regular chart in Excel, it usually has only one X-axis and one Y-axis. Combination charts in Excel let you present and compare two different data-sets that are related to each other (in a single chart).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |