Hello,

I have a chart with 2 lines from 2 different custom formulas. One shows the $ amount of sales from our Top 5 Customers and the other shows the $ amount of sales from our Top 10 Customers. Right now the data labels just show the amount spent.

I would like the data labels to show the percentage of total spend by all customers. I can create a custom formula like "Top 5 Spend"/"Total Spend", but that will only work for one of the lines and give me bad data on the other. Is there a way to create a formula that just takes whatever that monthly spend number is, regardless of what line it is on and divide by the total spend for the month?

Thanks!