Martin has attended:
No courses
Excel Charts
I have an array of data in one worksheet. This data consists of 57 survey questions, each question is in its own cell and all 57 form a column of 57 rows.
There are 5 individual responses for each question which are in their own cells and form 5 columns adjacent to the question. All responses are a single % figure, (% Positive).
The data is in a total of 57 rows and 6 columns. There is also a header row.
I would like to plot a line chart of the results, but have the line chart vertically so we can visually see the different responses as a % positive for each question.
I really hope this question makes sense.
Thank you in anticipation
RE: Excel Charts
Hi Martin
Thanks for getting in touch.
I think I followed most of what you were trying to describe. I have built a sample worksheet to try and emulate it.
I created some dummy data that I think is in your format. I then highlighted all of it and went to Insert > Line Chart.
Is this where you need to get to or have I missed something? I hope this helps.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
GF Line chart.xlsxRE: Excel Charts
Thank you Gary this is what I had in mind except the chart would be rotated 90 degrees clockwise.
I was also hoping to be able to take sections say the 5 responses to Q's 1 to 5 and then place in powerpoint.
Thanks
Martin
RE: Excel Charts
Hi Martin
Thanks for your reply. The Line chart type is designed to be horizontal, it doesn't have any options to be displayed vertially instead.
What you can do is copy the chart, and then Paste As Picture (look for the Paste drop down on the Home tab). You can then freely rotate this image, and paste into PowerPoint as needed.
If you only want to show certain values, I would select the chart, and then drag the boxes that surround the data to shrink them as required.
Failing that, a PivotChart might better suit your need to select and deselect different items. You can find this under the Insert menu, underneath PivotTable.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
