Apple Event: May 7th at 7 am PT

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

In-cell horizontal bar chart in Numbers

Am I able to add an in-cell horizontal bar chart in Numbers like I did in Excel?

iMac 21.5″, macOS 11.6

Posted on Oct 6, 2021 9:07 PM

Reply
Question marked as Best reply

Posted on Oct 7, 2021 4:33 PM


Basically the same as what was mentioned before but with only one data point in each chart. The charts are placed over a cell that the number in it. This is a multi-step process in Numbers: making the charts, editing the charts, placing the charts close to where they need to be, changing the row heights and columns widths, repositioning/aligning the charts, readjusting the row heights, etc. It is a detailed process. Not hard but a lot of little steps.

4 replies
Question marked as Best reply

Oct 7, 2021 4:33 PM in response to oldpos


Basically the same as what was mentioned before but with only one data point in each chart. The charts are placed over a cell that the number in it. This is a multi-step process in Numbers: making the charts, editing the charts, placing the charts close to where they need to be, changing the row heights and columns widths, repositioning/aligning the charts, readjusting the row heights, etc. It is a detailed process. Not hard but a lot of little steps.

Oct 7, 2021 4:28 AM in response to oldpos

Numbers does not have sparklines.


You can create a chart, remove all the unnecessary formatting (axis line, gridlines, legend, etc), resize it as small as it will go, and place it over a cell. You may have to make the row taller to fit the chart in the cell. It will not actually be a part of the table, though, so it will get misaligned if you move the table unless you select it at the same time. Also, if you add a row above the row that has the chart, it might make that new row a second series on your chart.


Oct 7, 2021 5:19 AM in response to oldpos

Hi oldpos,


Create the graph and Copy.

Click in a cell where you want the graph to appear and Paste.

The graph will be placed as an Image fill.

Resize that row and column to suit.


The image now belongs to the table and will move as you move the table or add rows above that row.

Be aware that the image fill is not interactive. If you modify the graph, the image will not change.


Regards,

Ian.




In-cell horizontal bar chart in Numbers

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