PC Review


Reply
Thread Tools Rate Thread

Arranging data to create a chart

 
 
Joyce
Guest
Posts: n/a
 
      28th Apr 2004
I need help on learning how to arrange data in a
spreadsheet to create a chart.






 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      29th Apr 2004
Joyce -

Put the X axis information (horizontal, labels or numbers) in the first
column. Put a blank cell immediately above the column of data. Put the Y
axis information (vertical, numbers) in one or more columns, to the
right of the X data. Put labels for these columns in the cells right
above the data. The data should look like this:

Name1 Name2 Name3
X1 Y11 Y12 Y13
X2 Y21 Y22 Y23
X3 Y31 Y32 Y33
X4 Y41 etc,

Select a single cell in this group (Excel will expand the selection), or
select the entire group, and run the chart wizard (Insert menu - Chart,
or Chart Wizard button on the command bars).

For more hints:
http://peltiertech.com/Excel/ChartsHowTo/index.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Joyce wrote:

> I need help on learning how to arrange data in a
> spreadsheet to create a chart.
>
>
>
>
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need an Idea on Arranging Data for a Chart Steve Haack Microsoft Excel Charting 1 11th Jun 2009 02:42 PM
Need Idea on Arranging Data for Chart Steve Haack Microsoft Excel Misc 0 10th Jun 2009 09:23 PM
Need help arranging chart theseandavis@gmail.com Microsoft Excel Misc 1 28th Jul 2006 10:28 PM
Chart data file lost - need to re-create from chart? =?Utf-8?B?TG9zdEV4Y2VsRGF0YQ==?= Microsoft Excel Charting 1 7th Jun 2006 07:54 PM
Arranging Data For Chart John Gregory Microsoft Excel Charting 3 4th Mar 2004 05:17 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:29 PM.