PC Review


Reply
Thread Tools Rate Thread

How do I make a Bar Graph?

 
 
=?Utf-8?B?VGF5bG9y?=
Guest
Posts: n/a
 
      22nd Sep 2005
How do I make a bar graph for class results? I tried and i came to step 2 of
4 and i dint not understand what i had to do at that part so if you could
please help me or respond before tomarrow thank you
 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      23rd Sep 2005
You must start with proper data. If you're plotting student scores, you
need two columns like this, with a title over only the values. The data
can be anywhere in the worksheet, not necessarily starting in cell A1.

Score
Alice 87
Bobby 65
Cindy 83
David 91
Elena 77

Select the entire range of data, or select just a single cell in the
data. Start the chart wizard, the little button with a column chart icon
on the Standard toolbar, or on the Insert menu, choose Chart. In step 1,
pick the chart type. In step 2 select the data, although if the data is
preselected, you shouldn't have to do anything here. In step 3 you can
choose from lots of other options, but if you want to go back to these
later, go to Chart Options on the Chart menu. Step four lets you choose
where to put the chart, either embedded by default in the worksheet with
the original data or in another sheet selected from the dropdown, or as
a sheet all on its own.

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


Taylor wrote:

> How do I make a bar graph for class results? I tried and i came to step 2 of
> 4 and i dint not understand what i had to do at that part so if you could
> please help me or respond before tomarrow thank you

 
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
how to make a bar graph lolprinze Microsoft Excel New Users 1 18th May 2010 08:14 PM
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? Charles A. Wilson Microsoft Excel Charting 1 17th Dec 2009 03:03 AM
how to make an XYY graph Jeff Lynum Microsoft Excel Charting 2 27th Feb 2009 12:19 PM
Can I make a graph to be a specific size? (actual graph) =?Utf-8?B?SmVzc2ljYQ==?= Microsoft Excel Misc 0 14th Aug 2006 08:45 PM
How do I make a graph? =?Utf-8?B?bmVlZGhlbHAxMjM=?= Microsoft Excel New Users 1 18th Sep 2005 12:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:42 AM.