Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to do this type of graph in numbers

Is there a way of doing this type of graph in numbers?



Thanks in advance.

MacBook Pro 13″, macOS 10.13

Posted on Apr 23, 2021 2:46 AM

Reply
Question marked as Top-ranking reply

Posted on Apr 23, 2021 4:51 AM

It is simple to make a chart with one data point. Use the scatter chart if you want it to be horizontal, it is the only one with a true X axis based one the value of the X data. Your data point is the X value. The Y value is a fixed number. For a vertical chart you could use the line chart with one category and with the Y value being your data point.



It takes a few steps.

  • You may have to change the chart to use columns as series (it will default to rows as series with just this one data point)
  • Adjust the axis min and max points for both axis. I used Y = 0 to 2 and X =-20 to 20 in my chart.
  • Turn off the y axis gridlines and labels
  • Turn off the chart legend
  • Resize the chart
  • Change the style of the data point to black with no fill, if that's what you want.


9 replies
Question marked as Top-ranking reply

Apr 23, 2021 4:51 AM in response to INDY-GO

It is simple to make a chart with one data point. Use the scatter chart if you want it to be horizontal, it is the only one with a true X axis based one the value of the X data. Your data point is the X value. The Y value is a fixed number. For a vertical chart you could use the line chart with one category and with the Y value being your data point.



It takes a few steps.

  • You may have to change the chart to use columns as series (it will default to rows as series with just this one data point)
  • Adjust the axis min and max points for both axis. I used Y = 0 to 2 and X =-20 to 20 in my chart.
  • Turn off the y axis gridlines and labels
  • Turn off the chart legend
  • Resize the chart
  • Change the style of the data point to black with no fill, if that's what you want.


Apr 23, 2021 8:38 AM in response to Yellowbox

Hi Ian,


The original chart wasn't mine...just one I was trying to replicate. For the background colours I'm just going to do advanced gradient fill and figure out where each block starts/ends by putting in the relevant data. Like Badunits below, though it will fill the whole space.


If I want it exactly the same (with a gap between the bottom line and blocks, I just use a few rectangles, as again suggested by Badunits below.


How to do this type of graph in numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.