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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am on numbers making garphs with data that I have put into excell. Now when I select data and go to make a graph not all my data shows up on the graph why? This also only happens for some of the graphs not all of them.
Mac Pro
I made the graph and the data in numbers I didn't mean to say Excell. I'm using the 2-axis option, but I can make any type of graph. No matter the graph it still only shows one set of data. The top graph shows both data and the bottom one will only show the one data.
The data is highlighted that I need. The graph above is only shows caffeine input not the sugar intake.
If you need to keep the units in the display, you can do that by setting a 'custom format' for the columns needing displayed units. As can be seen here, units displayed using formatting will not prevent the numbers being used in a chart:
Here's the format setting, created as a Custom format in the Cell Inspector, used in column E above:
Values in th formatted column are entered as numbers, without the g.
Regards,
Barry
I see two problems right off the bat.
Numbers is getting confused by these two things together. If you fix the data so it is all numbers (remove the g's and mg's), you should be able to plot the data correctly. You don't have to move the column/series names to the header row.
Are you making the graph in Numbers or Excel?
How did you move the data to Excel?
What type of graph?
Have you made any changes to the Numbers document?
Screenshot of the Table and Chart, with the Chart selected might help.
Regards,
Barry
At first glance, it looks like a merges cell in the header row could be causing the problem.
Regards,
Barry
Why is all my data not showing on my graph
