Excel Charts

Ideas on Comparison Charts

One of the frequently used chart type in excel is comparison charts. You have multiple options to design these in excel. Although the chart type is dependent on personal taste, here are different ideas to design these. You can also use comparison charts to show target Vs. actual and many more. The above is clustered column graph with Product B on secondary axis. Against axis options on secondary axis “Values in reverse order” needs to be checked.

Cluster Bar Graph while Product B is on secondary axix. Against axis options on secondary axis “Values in reverse order” is checked.

Stacked Column graph and Product B vales are in negative. Labels formatting in Product B is Custom 0;0;0

 

Clustered column Graph + Line with Markers Graph. In line graph line is transparent and Marker design is dash “-”

Clustered Column Graph

Clustered Column Graph. Product A is on secondary axis. Product A series Gap Width is 293%.

Clustered Colum + Line Graph

Line with Markers Graph

Product A Stacked Area + Clustered column Graph

Stacked Column Graph. The dummy series in the middle is invisible.

Stacked Bar Graph. The dummy series in the middle is invisible.

Stacked Bar graph and Product B vales are in negative. Labels formatting in Product B is Custom 0;0;0

Clustered Column Graph. Chart Tools > Design > Switch Row/Column

Stacked Column graph and Product B vales are in negative. Labels formatting in Product B is Custom 0;0;0

 

Leave a Reply

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