Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Aggregation for Chart in Excel

Status
Not open for further replies.
tbg130

tbg130

Programmer
Aug 11, 2004
46
CA
Hi All,

I've asked a question in the past but didn't manage to get the solution so thought that I asked the question wrong...

I have a summary table in Excel and need to make a chart from the data. The first column is a name of a country, and the second is a numeric value. I'd like to make a simple bar chart showing the TOP 5 values AND the sum of ALL OTHER listings...

Can this be done with Charts in Excel without having a 'sum' row for the 6th bar? The summary page really wouldn't make sense with a 'sum' included...

Any help you can provide would be SUPER GREAT...

Tyler
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
619
strongm
strongm
2009luca
  • Question
put value in input box web page
Replies
0
Views
227
2009luca
2009luca
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top