I was trying to create a Advanced funnel custom chart in Excel using combo option. I prepared the same using inverted axis, secondary axis, area chart, bar chart and line chart, . Only to find out that I can't rotate the chart by 90 degree (By rotating I get the final appearance as required. Enclosed)
Then I tried to use bar chart and line chart and added helping column to get the similar outcome but I am having hard time making the line chart understand to take numerical data on X axis and category on Y axis. Hereby enclosing the last step from where I want to have the the said Line chart)
Date is below if required:
| Sub-Category | Sum of Sales |
| Fasteners | 3024.28 |
| Labels | 12486.312 |
| Envelopes | 16476.402 |
| Art | 27118.792 |
| Supplies | 46673.538 |
| Paper | 78479.206 |
| Furnishings | 91705.164 |
| Appliances | 107532.161 |
| Bookcases | 114879.9963 |
| Copiers | 149528.03 |
| Accessories | 167380.318 |
| Machines | 189238.631 |
| Binders | 203412.733 |
| Tables | 206965.532 |
| Storage | 223843.608 |
| Chairs | 328449.103 |
| Phones | 330007.054 |