Forum Discussion
Solved
Adding Two Ranges for a Single Bar in a Chart
I have two ranges that I would like to add together for displaying in a bar graph. The data is laid out such that the X axis labels will be 7 sections for fiscal quarters (i.e., '22 Q4, '23 Q1, '23 Q...
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.
Thank you to both of you, both of these solutions would work for me. I'm surprised I didn't think of something as simple (but effective) as "just color the bars the same" XD. But, I also didn't think about creating named ranges that exist to be formula holders, either, and that's very useful. Either or both of these would work.