Currently Being ModeratedApr 9, 2012 8:47 AM (in response to laserblues2)
- Start with your table. Create the table and values you need
- Select the values to include by tapping on one cell and then dragging the selection handles
- When "Create Chart" Appears, tap it and select your chart type (pie in this case) - the chart will appear as 100% filled, don't worry.
- Tap the chart once and then tap Edit References - this will reveal a Gear Menu in the upper right
- Tap the gear and select "Plot Rows as Series" or "Plot Coumns as Series" as needed
You should now have a pie chart that you can modify the style to your liking.
Currently Being ModeratedApr 10, 2012 2:21 AM (in response to laserblues2)
Thanks, yes that's exactly what I've done, but for some reason the charts do not look the same.
The geniuses that I've shown couldn't understand it, and weren't able to help. I've read the manual and understand what 'should' happen....
Currently Being ModeratedApr 10, 2012 6:45 AM (in response to laserblues2)
Can you please give us a screenshot and indicate what is not as you would expect it to be?
Currently Being ModeratedApr 10, 2012 7:04 AM (in response to jaxjason)
Certainly, I'm not too sure on how I upload pictures here from my iPad, so here's a link to two images showing both types of chart
I think these should work as they are public photos.
Currently Being ModeratedApr 10, 2012 11:04 AM (in response to laserblues2)
Sorry, its a shame this section isnt optimised for iOS!!
Currently Being ModeratedApr 10, 2012 11:14 AM (in response to laserblues2)
Looking at your images, it seems as if you have no headers assigned to the tables.
Try 1 row and 1 column as headers, enter your pie wedge names in the vertical header for plot series by rows or enter your pie wedge names into the horizontal header for Plot series by column.
Try that and see if that makes a difference.
Currently Being ModeratedApr 10, 2012 11:34 AM (in response to bwfromspring hill)
Sorry, what do you mean? This was just an example, I would like a, b, c and d to be the titles of the segments....
Currently Being ModeratedApr 10, 2012 11:49 AM (in response to laserblues2)
use the paintbrush icon to format your table to include a header column.
After you do that, then tap your chart and edit references, make sure "plot rows as series" is selected.
This should do it for you.
Currently Being ModeratedApr 10, 2012 11:54 AM (in response to laserblues2)
If you'll notice in my examples above I created tables with a header row and a header column in each. In the left table, the first column has Stock A, Stock B, Stock, C, etc and the first row has Shares, $/Share and Value - the leftmost column is called a header and the upper most row is called a header as well. These are set by selecting the table then tap the Styles Menu > Headers > and entering 1 for Header Row and 1 for Header Column
The categories (or wedges) are Stocks and the values are Shares in this example.
Tap on the first cell in the vertical (column) header containing your "A" and then dragging a selection to include all of the categories and the column or related values in the adjacent column.
With the cells selected, tap on "Create Chart" then Tap on the Chart and tap "Edit References" and when the "gear" appears, Tap "Plot Rows as Series"
For the chart on the right, the only difference is that it is Plot Columns as Series.
Currently Being ModeratedApr 11, 2012 1:02 AM (in response to jaxjason)
Hi Jason, the header rows and columns are both set to one? I'm not sure whether I have to increase this? I've messed about with it, but it doesn't make any difference?
Sorry, I'm not sure I understand all the discussion regarding headers?
It doesn't seem very user friendly, you select what you want to create the chart and it doesn't seem to like it? Apples user friendly apps and nature don't appear to have been used for this app :-(
Currently Being ModeratedApr 11, 2012 9:45 AM (in response to laserblues2)
I am going to activate my email, pls click my name above and send a sample file to me so I can see what's going on.
Currently Being ModeratedOct 1, 2013 6:15 PM (in response to jaxjason)
HI there I am having the exact same problem have tried everything on this thread and a few others and cannot get the pie chart to change from 100% I was wondering if you had success with this other guy and if you could help me