How to create a bar graph in Excel 2010 by counts

0 votes
For whatever reason, I can't get this to function properly. I have a column of values that has a lot of A, B, C, and D grades.

I want to create a graph that displays the number of A, B, C, and D grades we have. I try to choose the values in the column (A2 to A(some big number)) for some reason after selecting Insert -> 3d Column graph, but it seems to be refusing to count anything. The bar graph itself only displays one flat category at level 0 and attempts to include all values in the title of the graph, such as "A B A C D A B..." and the legend. It has no use.
Oct 21, 2022 in Others by Kithuzzz
• 38,010 points
449 views

1 answer to this question.

0 votes

Read on usage of pivot charts:

enter image description here

Procedure:

Pivot Table:

  • Select Data
  • Insert Pivot Chart
  • Drag Value field to Row area and also to Data Area as Count of Value

Chart:

  • Select Pivot Table
  • Insert Column Chart
answered Oct 21, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

How to create a navigation bar in Flutter app?

Hi@akhtar, To add a drawer to the app, ...READ MORE

answered Aug 25, 2020 in Others by MD
• 95,440 points
671 views
0 votes
1 answer

How to multiply by a percentage range in Excel

The following would yield an array from ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 63,420 points
326 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,420 points
2,885 views
0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 63,420 points
441 views
0 votes
1 answer

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 63,420 points
734 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
• 63,420 points
545 views
0 votes
1 answer

Using Java to create PDF graphs based on Excel formulas

The Apache POI project, an API for ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 63,420 points
590 views
0 votes
1 answer

Is there a reason why these bars wont line up in my excel chart?

STEPS Hover your mouse over any of the ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 63,420 points
307 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,420 points
711 views
0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,420 points
422 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP