Best way to represent this data in excel chart

**masimo** · 03-17-2017, 07:41 PM

Hi,

I am new here and hope to find help. We are seriously understaffed and this is not my job but i am asked to do it but failed. I have data that looks like the image in excel 2007, which I exported from Crystal Reports. The original data is in sql server across many tables. The thing now is I am asked to represent the data in form of a chart. What chart type is suitable for this kind of tabular data of excel and how do I go about doing it? Note that i am very new to excel.

DoWhat_zpsluliq7jr.jpg

**MrShorty** · 03-17-2017, 08:37 PM

I might first suggest a 100% stacked bar or column chart. Being new to Excel, here's a help file from MS for creating column charts: https://support.office.com/en-us/art...0-e9ab353c4c00

Best way to represent this data in excel chart

LinkBack

Thread Tools

Rate This Thread

Display

Best way to represent this data in excel chart

Re: Best way to represent this data in excel chart

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dynamic chart to represent % of 52-weeks high and low of a stock

After Loop Completes, Chart doesn't represent new data

[SOLVED] How to have a graph/chart represent whether or not a cell h as been filled

Changing chart column width to represent time in excel

Is there a simple way or chart to represent multi dimensional data?

best way to represent data in Chart(graph)

Can't get chart to represent data correctly - 03 or 07

Bookmarks

Bookmarks

Posting Permissions