![]() |
add multiple x values to multiple instances of y coordinate
I have days of the month on the Y axis and a set of other numbers on the x axis. If I have 2 cells which are both labeled August 15th (for example), I want the data that corresponds to this entry to be added together along the x axis on the chart. Right now, the two sets of data do both show up on the August 15th bar, but subdivided within a single bar rather than being added together. Is there a way to do this?
Thanks for example: A, B aug 15th, 8 aug 15th, 10 I want the bar to show 18 rather than the bar being subdivided to show both the 8 and 10 and only going up to 10 on the x axis |
All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com