This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have come across numerous sites and examples of how to accomplish the following in Excel, but I can't figure out how to do it in Access (if it is possible):
I have a table from which I am attempting to plot 4 fields- Cost A, Cost B, Fund A, and Fund B. Records in the table also have an attached date. I am trying to plot costs and funds as a function of date. However, rather than having four separate columns side-by-side for each date (as you would get with a clustered column chart), I want only two columns. The first column is a total cost, which is a stacked column and shows Cost A on top of Cost B. The second is a total fund, which is a stacked column and shows Fund A on top of Fund B.
Thus, I am looking to accomplish something similar to the first image in the following website (though I would have my x-axis be a date):
http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/
Other sites related to accomplishing this in Excel use a similar method to the one in the link above and rely on including "dummy" or blank data to get the chart to plot the series separately. I can see how I could reconstruct this kind of table in access with blank fields (using a combination of select and append queries- plus, I have a feeling it would be pretty messy), but I'm not sure how I could get access to then group the data appropriately to treat them like separate series.
Has anyone accomplished this or have any thoughts on how it might be done?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Bueller. Is this thing on?
Seriously though, is this just something that Access is incapable of or just that nobody knows how to do it?
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Bump. I am still looking for an answer!
I'm still looking for any help or suggestions on this issue. Right now, I can only get two stacked columns that lie on top of one another (by placing one on primary and the other on secondary axes). In order to view them both, I have to make one set thinner than the other, so it really looks like one stacked column inside of another. This is alright for the moment, but it's not intuitive to read and interpret.
So if anyone has a suggestion for getting Access to plot two series of stacked columbns side-by-side, as described in the OP, I would really appreciate the help.
Thanks!
Does anyone have any advice they can offer, please?