-2

I have the following chart in excel. It has listed the features and companies who are supporting the features. Hence, It has Yes or No values in it. I want to display nicely in excel chart. I tried using PivotTable report, but it didn't accept this data for pivottable. Could someone guide me what is the best excel chart for showing this report visually?

enter image description here

Stella
  • 1,728
  • 5
  • 41
  • 95

2 Answers2

0

One option can be to use number like 1 or 2 in place of Yes and No and then using that you can create bar graph depending upon which part (feature or company) you want to keep as base for this statistics.

Anutosh
  • 29
  • 2
0

As mentioned earlier you can assign any value to Yes and No. In the below screen shot it is 1 for Yes and 0 for No. This is a simple bar graph in excel. Please explore other graph styles to suit your need.

This is just to give an direction to the thought process. Hope this helps.

See the partial screenshot

Anutosh
  • 29
  • 2
  • Good. I don't see bar chart in this vertical style. I get only in horizontal style in my MS excel, so instead of company in your case for me it is showing feature, which is not correct for me. But your chart shows better and correct. Do I need rotate my chart to visualize like your's or ? I am trying on Mac. – Stella Sep 08 '16 at 02:35
  • Please use stacked column style. You may have selected stacked bar style when creating the chart hence the horizontal bars. You can select the chart area and then select 'Change Chart Type' from the top menu bar and select the one fitting your need. The above chart is done on Mac using excel 2015 for Mac. Hope this helps. – Anutosh Sep 08 '16 at 04:52
  • I selected stacked column only but it is reverse to me than your graph, i.e instead Feature 1, it is Company 1 for me, I'll try again and update. Thanks – Stella Sep 09 '16 at 03:48