How to create comparative line chart in Excel with combo box?

Share Now


Check below a sample comparative line chart with combo box, which will give a cool comparison look to your data. With the help of combo box you can focus on each region and can compare it with others. Click Here to download a sample workbook.Comparative line Chart

Step to create cool comparative line cart in excel:

1) Add reference, row or column in your data. Here I have added reference row (see the below screen shot).

2) Now create the line chart by selecting the whole data. For creating line chart, Select data > Click Insert Tab > select Line chart.

3) Change the line color of East, West, North and South Region to light cream and Reference1 line color to red.

4) Now add the combo box control form developer tab under Control Panel > Insert box. Right click on combo box select Form Controls. In input range select C3:C4 and cell link C1.

5) Now insert Offset function in reference row (from cell C7:H7).
Cell C7 = “=OFFSET($C$2,$C$1,0)”
Cell D7 = “=OFFSET($C$2,$C$1,1)”
Cell E7 = “=OFFSET($C$2,$C$1,2)”
Cell F7 = “=OFFSET($C$2,$C$1,3)”
Cell G7 = “=OFFSET($C$2,$C$1,4)”
Cell H7 = “=OFFSET($C$2,$C$1,5)”

Note: To learn more about Offset function click here



Share Now
November 15, 2019

0 responses on "How to create comparative line chart in Excel with combo box?"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    Social Media

    ECAnalytics-facebookECAnalytics_Linkedin

    Address:

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED