I am trying to make a cluster chart categorized by different emails sent out to customers (Let us call them Email 1, 2, and 3) and have each email type stacked based on the response (opened and clicked). Is it possible to have your chart be both clustered and stacked? The x-axis is labeled by the day of the week, and I would further group it by the email (1, 2, and 3) on each day.
Thank you in advance for the help!
Numbers
I must not understand how to uses this discussion group. I tried to submit new question & maybe I am not patient but don't see anything happening.
I am trying to find out how to create new categories in the Numbers budget templates
Numbers doesn't have a cluster stacked column chart. But you can use a 3D Stacked Column and can "cheat"similar to the way you would in Excel.
The trick is to leaving the blank rows in the data table which, when the color fill is removed, form the gaps between the clusters.
I haven't figured out how to getting the labels for each cluster into the right place. When the two left columns are defined as Header Columns the cluster labels appear where shown in the screenshot, not ideal. It's possible the days of the week may have to be labeled manually with text boxes.
SG
Hi allie,
Following on from SG,
Regards,
Ian.
Thank you both for your help! If you wouldn't mind helping with one last detail, I can't figure out how to get the "type" column to not be included in the stacked bars. Mine looks like this:
Are your columns A and B defined as Header Columns?
Also from the screenshot it looks as if you don't have a Header Row at the top where you place the labels.
SG
I figured out the problem. I am technically on Pages, but I figured the formatting of charts would be the same on both programs. There is no way on Pages to add an extra header column, so I ended up cheating and using the axis name to categorize as such:
I see. So your screenshot is of the Chart Data window in Pages. And for the day names you just checked Axis Name and then double-clicked and typed the names into the axis name box, spacing them manually until they align with the clusters in the chart.
SG
That is correct! Thank you for the team work to solve this problem.
How do you make a stacked cluster chart?
