Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Excel Help for Mac PLEASE!!!
- Thread starter theturtle
- Start date
- Sort by reaction score
Include the column headers in the selected area before you click the chart:
or with all of them:
No, don't select one range, then add the other range. Drag to select it all in one range.
Not this:
But this:
If only want Baltimore, move Seattle out of the range.
Not this:
first just wanted to say thank for taking the time out and actually going through the process with me!
but anyways, you were right, when i deleted the seattle row, the graph came out like i wanted, but when i added the seattle row back in, it somehow modified itself. how would i get just baltimore without adding in seattle? i thought the selecting one line than selecting the other items via command was the answer but yeah, it gave me a messed up graph.
I showed you in the first graph I posted. In this example, drag and select A2:G5 then click the chart (you don't need the blank rows 3 and 4 if you don't want them):
I showed you in the first graph I posted. In this example, drag and select A2:G5 then click the chart (you don't need the blank rows 3 and 4 if you don't want them):
got it got it. last question than!
i have to create a bar chart of the total rainfall. how would i make it so it just has the months and the total rainfall? when i did the dragging method, it listed all the info and when i would try to delete the bars i dont need, it would delete everything. so if i chose to delete the chicago bars (everything except the total rainfall column) everything would delete.
the second chart im supposed to make is a pie chart for chicago. but when i try the dragging method, because chicago is on the bottom and all data is selected, seattle is the data the comp uses to make a graph.
i should note, the spreadsheet i have cannot be changed. so i cant take switch chicago with seattle, vice versa.
I'm getting the feeling now that I'm doing your homework for you, which I'm not inclined to do. I may be wrong, but it sounds like the point is for you to learn how to do it yourself. Good luck!
not really...
would you like to see the graphs i already made?
if google doesn't tell me than who exactly am i supposed to turn too?
i also put in "change categories excel mac" but came up empty. i actually have been searching for maybe an hour or two.
it doesnt help when the computers we're taught on are excel 07.
theres the proof that i completed the assignment
its not that i need help finishing, its that i need help revising (and learning for fuure references).
for example, the only way i was able to get only chicago to show up or do the total rainfall only was to rewrite the data and select that. my question is, if theres any other method that would allow me to reach those graphs without rewriting the info.