SilverTRader
New Member
- Joined
- Apr 30, 2013
- Messages
- 9
The totals from daily activty is on Row 4 for about 50 companies names listed on Row 5
The graph from this only wants to:
a. Show the top 10 companies based on the associated totals
b. Alwasys include Our company in the top 10.
Static:
Row 4 Column D to Az - List of totals for each column
Row 5 Column D to Az - List of compananies (in Alphabet order) Our company in middle
Grows Daily - daily sales numbers beow:
The row 4 Column Total is based on rows below it that are added with daily sales.
the rows below start 1/2/2013 --> to current date
Each date's row shows total sales for each company as it is published daily.
Each day, after the day's sales are entered, a chart needs to be created showing the top 10 companies.
But, Our company always needs to be included in the top 10 weather it made the top 10 or not.
Alternative:
If Our company can't always be included in the top 10, then perhaps a trend lind across the chart showing Our company - this would show what companies are above and below Our company.
A Formula or VBA Code would be acceptable. Any links to examples for charting with code or an update would be great.
Somewhat related is this article: Extract largest values from two columns using array formula in excel | Get Digital Help - Microsoft Excel resource
The graph from this only wants to:
a. Show the top 10 companies based on the associated totals
b. Alwasys include Our company in the top 10.
Static:
Row 4 Column D to Az - List of totals for each column
Row 5 Column D to Az - List of compananies (in Alphabet order) Our company in middle
Grows Daily - daily sales numbers beow:
The row 4 Column Total is based on rows below it that are added with daily sales.
the rows below start 1/2/2013 --> to current date
Each date's row shows total sales for each company as it is published daily.
Each day, after the day's sales are entered, a chart needs to be created showing the top 10 companies.
But, Our company always needs to be included in the top 10 weather it made the top 10 or not.
Alternative:
If Our company can't always be included in the top 10, then perhaps a trend lind across the chart showing Our company - this would show what companies are above and below Our company.
A Formula or VBA Code would be acceptable. Any links to examples for charting with code or an update would be great.
Somewhat related is this article: Extract largest values from two columns using array formula in excel | Get Digital Help - Microsoft Excel resource
