Modify chart data in Pages on Mac (2024)

Modify chart data in Pages on Mac (1)

You can modify a chart’s data (numbers, dates, or durations) at any time. You can add and remove an entire dataseries, or edit a data series by adding or deleting specific data from it.

Add or delete a data series

  1. Click the chart, click Edit Chart Data, then do any of the following:

  2. Close the Chart Data editor to return to the chart.

Switch rows and columns as data series

When you add a chart, Pages defines the default data series for it. In most cases, if a table is square or if it’s wider than it is tall, the table rows are the default series. Otherwise, the columns are the default series. You can change whether rows or columns are the data series.

  1. Click the chart, then click the Edit Chart Data button.

  2. Click the row or column button in the top-right corner of the Chart Data editor.

    Modify chart data in Pages on Mac (3)
  3. Close the Chart Data editor when you’re done.

Share the x-axis for multiple values along the y-axis for scatter and bubble charts

Sharing the x-axis means plotting a single kind of value along the x-axis, while allowing for multiple kinds of values plotted along the y-axis. By default, the x-axis values are shared among multiple sets of y-axis values in some types of charts.

  1. Click the chart to select it, then click the Edit Chart Data button.

  2. Click Modify chart data in Pages on Mac (4), then select Share X Values.

  3. Close the Chart Data editor when you’re done.

About chart downsampling

If a column, bar, line, or area chart references a table with a large number of data points, the chart automatically shows a representative sample of each series to improve the performance of Pages. Downsampling doesn’t change or remove the data in your table, and only changes the visible data points in the chart.

If your chart data is being downsampled, a message appears when you click Large Data Set in the Chart tab of the Format Modify chart data in Pages on Mac (5)sidebar.

If you want to see certain data points in your chart, you need to create the chart from a smaller table or a smaller selection of data from a large table.

Modify chart data in Pages on Mac (2024)

FAQs

How to make a chart in Pages on Mac? ›

in the toolbar, then click 2D, 3D, or Interactive. Click the left and right arrows to see more styles. Click a chart or drag one to the page. To add data, click the chart, click the Edit Chart Data button near the chart, then enter your data in the Chart Data editor.

How do I change the chart type on my Mac? ›

You can change a chart from one type to another—for example, from a column chart to a bar chart, or from a 2D chart to a 3D chart. Click the chart to select it, then in the Format sidebar, click the Chart tab. Click the Chart Type pop-up menu at the bottom of the sidebar, then choose an option.

How do you edit data in a chart? ›

In Word and PowerPoint: Select your chart and then on the Chart Design tab, click Edit Data in Excel. In Excel, select the category title and then in the Home tab, click Sort & Filter > Filter. Next, click the drop-down arrow to select the data you want to show, and deselect the data you don't want to show.

Where would you click to edit the chart data? ›

The Chart Tools tab appears only when a chart is selected, and the Design, Layout and Format tabs under it provide different commands that relate only to the selected chart. Under Chart Tools, on the Design tab, in the Data group, click Edit Data.

How do I change the chart type? ›

On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use. The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type category.

What is the shortcut for chart on Mac? ›

Shortcut key for creating charts in Excel 365

It is the right one, with the three keys you need to press (FN + option + F1).

What is the shortcut key for change chart type? ›

If you click inside some data, and then press Alt+F1 on your desktop keyboard (or Alt+Fn+F1 on a laptop), Excel will provide a chart and use the default chart type. Usually this is a clustered column chart. But you can change the default if you want.

How do I edit data in a data view table? ›

Double-click the table cell. As an alternative, you can right-click the table cell and click Edit Value. Change the contents of the cell and press Enter.

How do I edit a table in pages? ›

Change the look of a table: Click the table, then use the controls in the Table tab of the sidebar to make changes, such as adding a table title or outline.

How do I edit a table chart? ›

On your computer, open a spreadsheet in Google Sheets. Double-click the chart you want to change. Table. Change how the table looks, sort the table, or add pagination.

Top Articles
Debt Ceiling and the Markets | U.S. Bank
Is Teladoc Stock a Buy? | The Motley Fool
What Is Single Sign-on (SSO)? Meaning and How It Works? | Fortinet
#ridwork guides | fountainpenguin
Compare Foods Wilson Nc
Dte Outage Map Woodhaven
Star Sessions Imx
Google Jobs Denver
AB Solutions Portal | Login
Derpixon Kemono
Bernie Platt, former Cherry Hill mayor and funeral home magnate, has died at 90
Cbs Trade Value Chart Fantasy Football
Vipleaguenba
Craigslist Mt Pleasant Sc
Vrachtwagens in Nederland kopen - gebruikt en nieuw - TrucksNL
No Hard Feelings - Stream: Jetzt Film online anschauen
Hermitcraft Texture Pack
Ein Blutbad wie kein anderes: Evil Dead Rise ist der Horrorfilm des Jahres
Governor Brown Signs Legislation Supporting California Legislative Women's Caucus Priorities
Www.patientnotebook/Atic
Slim Thug’s Wealth and Wellness: A Journey Beyond Music
Wnem Tv5 Obituaries
Sessional Dates U Of T
Weathervane Broken Monorail
Labcorp.leavepro.com
Truvy Back Office Login
Gillette Craigslist
Studentvue Calexico
Till The End Of The Moon Ep 13 Eng Sub
Elanco Rebates.com 2022
Devotion Showtimes Near The Grand 16 - Pier Park
Dentist That Accept Horizon Nj Health
Scat Ladyboy
NIST Special Publication (SP) 800-37 Rev. 2 (Withdrawn), Risk Management Framework for Information Systems and Organizations: A System Life Cycle Approach for Security and Privacy
Craigslist Red Wing Mn
Atlantic Broadband Email Login Pronto
Facebook Marketplace Marrero La
Edict Of Force Poe
Boggle BrainBusters: Find 7 States | BOOMER Magazine
About :: Town Of Saugerties
Sukihana Backshots
Carroll White Remc Outage Map
Trivago Sf
Academic Notice and Subject to Dismissal
About Us
Best Suv In 2010
4Chan Zelda Totk
2487872771
Sj Craigs
Latest Posts
Article information

Author: Kieth Sipes

Last Updated:

Views: 6085

Rating: 4.7 / 5 (67 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Kieth Sipes

Birthday: 2001-04-14

Address: Suite 492 62479 Champlin Loop, South Catrice, MS 57271

Phone: +9663362133320

Job: District Sales Analyst

Hobby: Digital arts, Dance, Ghost hunting, Worldbuilding, Kayaking, Table tennis, 3D printing

Introduction: My name is Kieth Sipes, I am a zany, rich, courageous, powerful, faithful, jolly, excited person who loves writing and wants to share my knowledge and understanding with you.