Numbers chart using a second table data series

Question

Numbers chart using a second table data series

Numbers chart is not displaying data points from a second table data series, even though the chart legend includes the data.

Here is the chart, a 2d scatter chart formatted to look like a timeline.

The two data series are from two separate tables, looks like this.

The dates on the top non-header row are the x-axis data, all the -100's are just to force any repetition of data points off the scale of the chart.

There is one only column header and row header on both data tables.

The header column (y data point) in each data series can be turned off (no displayed) by each lined section, using lookup logic in a third table, and a non-displayed entry in the header column also turns off display of the corresponding date in in top row.

I did a proof of concept at one point early on that showed I could combine data series across two table, but now can not make this work. Data from the second data table is showing up in the chart legend as shown, but the corresponding data points do not display in the chart.

Can anyone suggest what I am doing wrong?

thanks!

MacBook Pro 16″, macOS 13.4

Posted on Jun 1, 2023 9:29 AM

Reply

Answer 1

SGIII

Level 8

37,550 points

Jun 1, 2023 9:38 AM in response to Bythe_numbers

Your "timeline" chart looks intriguing!

In the top visible row of the first one you go from 0 to 18, but in the second one you have 0 to 9, and restart at 0 again after that. Could that be part of the problem?

SG

Reply

Answer 2

Jun 5, 2023 9:14 AM in response to SGIII

No, that part is working well. It is just each event can repeat in time up to a certain iteration count, spaced a certain time period apart. That charts just as expected. I did contact Apple support, and the answer I got was that Numbers doesn't support data from a second table being included in the chart. I don't think that is a right or complete answer, as I can include the second table, and eventually found that adding a second data range for the second table was possible by editing the data series x value and adding a second row separated by comma.

but still the chart is not displaying the data points from the second table.

My answer I am working on now is to combine the tables by transposing rows and columns, and then merging the table data. This allows all the data to fit with the 1000 column table limitation, so should work.

Reply

Numbers chart using a second table data series

Similar questions