Forum Discussion
Adding Two Ranges for a Single Bar in a Chart
Whilst a Series definition might not accept an array formula, it will accept a defined name (sheet local names are useful because the name must be fully qualified by its parent sheet or book, and users tend to create shorter names on sheet tabs than for file names). The Name then contains the formula.
Note1: The concept of a named range is only a special case of the named formula in which the name happens to resolve to a sheet reference.
Note2: In extreme cases, complex charts can be created with no numbers coming from worksheets.
nkapran Sorry for having left the issue hanging a bit. I simply couldn't visualise what you were dealing with. Re-read you postings and had an idea that might help you.
Try creating a Stacked bar chart and match the colour of both series. Then you can create something like this:
It looks like a regular bar chart based on one series, but actually it took two without the need to sum them. File attached.