Hottest Free Downloads - DownloadPipe.com Over 197,000 downloads! Bookmark Now!
DownloadPipe.com - New Downloads Every Minute
 SEARCH:
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

making a table into a chart

 
   Mac (Home) -> Mac Excel RSS
Next:  Finding SUM ignoring zero or blank values  
Author Message
DocRock

External


Since: Jan 02, 2009
Posts: 1



(Msg. 1) Posted: Fri Jan 02, 2009 10:41 pm
Post subject: making a table into a chart
Archived from groups: microsoft>public>mac>office>excel (more info?)

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I'm new to Macs and the 2008 versions of Office, especially Excel, which I only ever use to enhance PP. I've made a simple table in Word. I click on charts and pick an appropriate line chart. Then Excel opens with a sample table that does not have my data in it. When I scroll around I finally find my data with the chart inside it (which messes with the columns of course). But even then it doesn't have the data displayed properly (i.e., the y axis has values that don't correspond to the data). Any suggestions?
Back to top
Login to vote
CyberTaz

External


Since: May 06, 2006
Posts: 1252



(Msg. 2) Posted: Sat Jan 03, 2009 8:58 am
Post subject: Re: making a table into a chart [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yeah, IMHO 2008 takes what used to be a simple straightforward process &
turns it into a real PITA to create a chart from a Word table Smile Of course
you can always use Insert> Object> MS Graph Chart instead, but then you're
giving up all the new & cutesy SmartArt enhancements. Try this:

First, turn on the non-printing characters (¶) in your Word document so you
can tell where your paragraphs are, then select & copy your table.

Next - very important - Do Not leave the table selected & Do Not leave the
insertion point *in* the table. Instead, click in the empty paragraph where
you want the chart to go. Then click the icon for whatever type of chart.

Once Excel launches, paste your data into the sample data area & then adjust
the frame around the cells as necessary using the lower right corner of the
cell range. [Have a look at Word Help on: Create a Chart]

That should give you the chart you want where you want it Smile

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 1/3/09 12:41 AM, in article 59b686d2.-1.DeleteThis@webcrossing.caR9absDaxw,
"DocRock@officeformac.com" <DocRock.DeleteThis@officeformac.com> wrote:

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
>
> I'm new to Macs and the 2008 versions of Office, especially Excel, which I
> only ever use to enhance PP. I've made a simple table in Word. I click on
> charts and pick an appropriate line chart. Then Excel opens with a sample
> table that does not have my data in it. When I scroll around I finally find my
> data with the chart inside it (which messes with the columns of course). But
> even then it doesn't have the data displayed properly (i.e., the y axis has
> values that don't correspond to the data). Any suggestions?
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Chart Category Axis Zero - I'd like to make my categories in a chart start with the number zero. In other words, I want the bar graphs to be zero, one, two, etc. But it will only start with one. Any suggestions?

How do I insert titles in a chart - Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I used to run excel in windows and I had it down pat.. Now I am using a macbook and creating charts is extremely slow and I can't even figure out how to put titles into the charts....

line column chart - Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel My teacher asked me to make a line/column chart. It looks to me like I can only do either/or, how do I put both on one? He showed us how to do it in the 2003 version, but I can't..

how do you create a chart on excel?? - Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I really don't know much about excel, but i'm trying to list all my expenses and I want to know exactly where/on what my money goes to. Can anyone help me ??? tnxx

Excel chart formats - Version: 2008 Operating System: Mac OS X 10.5 (Leopard) When I create a scatter plot the chart axes are positioned through the middle of the chart. Is there a way to change them to run the traditional way, along the outside?
       Mac (Home) -> Mac Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
Categories:
 Windows Forums
 Game Forums
 Linux Forums
  Mac Forums
 PDA Forums
 Mobile Forums
  Top  |  Store  |  RSS Feeds RSS  |  Data Feeds  |  Advertise  |  Submit  |  Bookmark  |  Newsletter  |  Contact