Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

This takes care of the data in the worksheet but how to utilize the named formulas in the chart?

April 26, 2017chart Data formulas named takes utilize worksheet

0

Posted

This takes care of the data in the worksheet but how to utilize the named formulas in the chart?

1 Answer

0

Posted

The easiest way to create the chart for this example is by using the existing data in SalesInfo sheet. Create the chart and then edit the =SERIES() formulas for each data point in the chart itself as shown here. Note: To edit each series formula: in the chart click on (in our example) each column in turn that represents a series and you can edit the formula for each in the formula bar.