Hello, I understand we plot 2 Y axis while keeping X-axis non-numeric. Im interested in plotting 2 Y-axis (on either side) with X axis being a numeric. Is there a way to do in Keynote charts (Mac OS) ?
Thanks in advance for your time.
I don't think that is currently possible in either Numbers or Keynote. The x-axis is categories.
You could consider giving feedback to Apple via Numbers > Provide Numbers Feedback in your menu, or the equivalent in Keynote.
SG
Hi kvummidi,
While we all wait for Apple to introduce a 2 Y-axis scatter plot with a linear (variable, not category) X axis, perhaps we can cheat.
The table on the right has one Header Row and one Header Column (as is usual for a Category graph).
Column A is Actual values (Text).
Formula in B2:
XLOOKUP($A2,Raw Data::$A,Raw Data::B,"",0,1)
Fill down and fill right.
That leaves blank rows where date are missing. Therefore there are no data points within the evenly-spaced X axis in the pseudo scatter plot..
All comments are welcome.
Regards,
Ian.
Hi SG,
User Tip done!
Numbers: 2D 2-Axis Pseudo Scatter Plot - Apple Community
Thanks for your input. Please feel free to edit.
SGIII wrote:
Do User Tips still exist?
SG
Yes. This list was created by Lounge member askbarnabas
User Tip Library - Apple Community
Regards,
Ian.
Sorry, I posted without the Pseudo Scatter Plot.
Ian.
Very helpful!
I tried it with some "dates" (making sure they were entered as Text).
Time for another Yellowbox User Tip? (Do User Tips still exist?)
SG
Hi Ian,
Thanks. I have bookmarked that list. It needs updating to include your latest contribution!
SG
2 Y axis with X-axis also being numeric
