Need an Excel Pro. How do I have two sets of data in one column?
So I'm trying to figure out how to include a subset of data on each existing column. It would sort of look like my poor attempt at a drawn example. Trying to measure both quantitative data (the columns I already have up) and qualitative data (what would be a smaller number representing the successful calls within that overall quantity).
Can anyone help me???
Please provide instructions as I am an excel noob.
- David KLv 61 month agoFavourite answer
A stacked chart is not the answer; you need an overlay chart. Here is a page that will guide you through it: https://www.exceltip.com/excel-generals/how-to-ove...
- Anonymous1 month ago
I think you want to use a stacked bar chart.