John Nixon
New Member
Attached is a chart I am trying to recreate with my data. Where on the Y Axis you have ranges of revenue and then within the stacked columns you have a count of the number of companies that fall in to that range.
I have attached an old Excel document. In that document is a list of companies. What I want to do is actually create a stacked column where ranges of revenue on the Y Axis, are charted against Industry Type in the X Axis with a count of companies that fall within each of the ranges.
This would allow me to say, "We've got X number of [Industry label in Excel file] companies, who have revenues between $100M and $500M", for example; and then if I filter on country, then the Pivot Chart updates to show the stacked columns for that country or countries.
I have attached an old Excel document. In that document is a list of companies. What I want to do is actually create a stacked column where ranges of revenue on the Y Axis, are charted against Industry Type in the X Axis with a count of companies that fall within each of the ranges.
This would allow me to say, "We've got X number of [Industry label in Excel file] companies, who have revenues between $100M and $500M", for example; and then if I filter on country, then the Pivot Chart updates to show the stacked columns for that country or countries.
Attachments
Last edited:
