Hello.
I have a simple blended axis chart, as shown below:
In this chart, I want to accurately label "sum(sales)," "sum(profit)," "profit ratio," and "sum(quantity)" at desired location. All categories should be labeled in the specified locations. For example, in the "Technology" category, at location (1), I want to label "sum(sales)," which is 839893 (in orange). At location (2), I want to label the sum(profit) and Profit ratio, which is 146543, and 146543/839893= 17.4%, both in blue color. At location (3), I want to label sum(quantity), which is 7017 in red color.
How to do that? Workbook attached.
Thanks, Tom
Thanks for your reply. I have attached the workbook in the post. Could you make this happen with the attached workbook?
Thanks,
Tom