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
Call for Action: After 15 years, it is time to reformulate the Santiago Principles (GlobalSWF)
25 Problem solving interview questions & answers - Clevry
Automated refuse, recycling for most residences; schedule announced | Lehigh Valley Press
Dairy Queen Lobby Hours
It's Official: Sabrina Carpenter's Bangs Are Taking Over TikTok
Enrique Espinosa Melendez Obituary
Erika Kullberg Wikipedia
A Complete Guide To Major Scales
The Potter Enterprise from Coudersport, Pennsylvania
Call Follower Osrs
Back to basics: Understanding the carburetor and fixing it yourself - Hagerty Media
Fcs Teamehub
24 Hour Walmart Detroit Mi
Apne Tv Co Com
Unlv Mid Semester Classes
Grab this ice cream maker while it's discounted in Walmart's sale | Digital Trends
Michael Shaara Books In Order - Books In Order
The Grand Canyon main water line has broken dozens of times. Why is it getting a major fix only now?
Walgreens Tanque Verde And Catalina Hwy
Walmart Near South Lake Tahoe Ca
Imouto Wa Gal Kawaii - Episode 2
Strange World Showtimes Near Savoy 16
Manuela Qm Only
Nk 1399
Creed 3 Showtimes Near Island 16 Cinema De Lux
Orange Park Dog Racing Results
Will there be a The Tower season 4? Latest news and speculation
Shoe Station Store Locator
Everything You Need to Know About Ñ in Spanish | FluentU Spanish Blog
Sf Bay Area Craigslist Com
Craigslist Maryland Baltimore
Newcardapply Com 21961
Federal Student Aid
Ljw Obits
Pay Entergy Bill
The Banshees Of Inisherin Showtimes Near Reading Cinemas Town Square
Colorado Parks And Wildlife Reissue List
Clima De 10 Días Para 60120
Ferguson Showroom West Chester Pa
Man Stuff Idaho
Cnp Tx Venmo
Best Restaurants West Bend
ACTUALIZACIÓN #8.1.0 DE BATTLEFIELD 2042
2017 Ford F550 Rear Axle Nut Torque Spec
'The Night Agent' Star Luciane Buchanan's Dating Life Is a Mystery
Grand Valley State University Library Hours
Boyfriends Extra Chapter 6
Bellelement.com Review: Real Store or A Scam? Read This
Gear Bicycle Sales Butler Pa
Hkx File Compatibility Check Skyrim/Sse
Ssss Steakhouse Menu
Lux Nails & Spa
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.