Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

How to create a Bar Graph with this data in Excel

Excel 2007.

How do I create a bar-graph with (# of rooms) as X-axis and "Number of students" as y-axis


# of rooms      Number of Students
36                  1
32                  2
31                  1
26                  1
25                  2
24                  1
22                  2
21                  3
20                  6
19                  3
18                  4
17                  6
16                  8
15                12
14                14
13                  9
12                10
11                10
10                11
9                 4
8                 4
7                 1
1                 89
0
prain
Asked:
prain
1 Solution
 
Saqib Husain, SyedEngineerCommented:
If you have this in A1 to B24 where row 1 has the titles then delete the title # of rooms from A1 and then select the data range A1:B24 and then insert a column chart.
0
 
prainAuthor Commented:
Phew. It worked. Thank you! Tank you! Thank you! indeed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now