Tag: excel chart secondary axis

If you have two data series that are related, but not comparable, it might be tough to chart it. For example, let’s say you have data representing the sales of products. You also have the production costs. When you subtract the production cost from the sales data, you get the…

Placing two data sets in an Excel chart is an effective way to quickly understand data and make important business decisions. However, when the values in your data sets widely vary, your chart may be difficult to comprehend. A great way to mitigate this problem and make your data clear…