Forum Discussion
Kishan98
Feb 16, 2023Copper Contributor
Advanced Combo chart (Funnel)
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 |
No RepliesBe the first to reply