Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Im trying to create this chart in keynote. However I cant seem to change a 2d bar chart to just display as symbols (dots for the data points) and if i use a line chart i cant just swap the axis so that the categories run up the y axis and the values run across the x axis. Any idea how to create this in numbers / keynote please?
Something like this?
It's a little bit of a hack.
Add a column to your data table with slightly larger values than the actual ages. 0.5 worked here. Use 2d Stacked Bar and plot, giving you something like this.
Click Edit Data References and delete the Age column from the references.
Click Create Custom Format under Value Labels:
Create a rule something like this:
Or, even easier, just this seems to work:
I pasted in this for the circle character: ◦
You could use whatever other marker you want from Show Emoji and Symbols (under the input part of the Mac menu bar)
Click the series (bars) and in Style tab set Fill to No Fill.
Continue to format to taste, removing legend, varying the steps in the axes, etc., to get the scale in my top screenshot.
You may need to drag the chart slightly wider or narrower (and/or add leading spaces in the custom format) to get the circle markers to line up properly.
SG
Something like this?
It's a little bit of a hack.
Add a column to your data table with slightly larger values than the actual ages. 0.5 worked here. Use 2d Stacked Bar and plot, giving you something like this.
Click Edit Data References and delete the Age column from the references.
Click Create Custom Format under Value Labels:
Create a rule something like this:
Or, even easier, just this seems to work:
I pasted in this for the circle character: ◦
You could use whatever other marker you want from Show Emoji and Symbols (under the input part of the Mac menu bar)
Click the series (bars) and in Style tab set Fill to No Fill.
Continue to format to taste, removing legend, varying the steps in the axes, etc., to get the scale in my top screenshot.
You may need to drag the chart slightly wider or narrower (and/or add leading spaces in the custom format) to get the circle markers to line up properly.
SG
Thats great I'll give it a try thank you! Cant help but feel im trying to do something really simple which keynote should be able handle in a straight forward way by flipping the axis in a line chart or changing the appearance of the bars in a bar chart to circles.
Yes, I agree charts can be hard. They're not fully documented. Trying different things to see what "works" can be an effective approach. I did not know it was possible to create this kind of effect until I tried to find a solution to your question. Thanks for the green tick!
SG
2nd screenshot is when i plot the rows as series on the line chart.
For Numbers, what does your data table look like?
SG
Did you try it? That takes only a few minutes.
SG
I tried it and it worked well. Thank you very much for the solution! I do think Keynote could make this much simpler to achieve. It seems a basic visual to try and replicate.
Keynote/numbers chart - Swapping x/y axis
