You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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.