98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Charts
Excel Charts
Resolved · Low Priority · Version 2010
Fri 2 Aug 2013, 16:08Delegate Martin said...
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
Fri 2 Aug 2013, 16:37
Edited on Fri 2 Aug 2013, 16:38Trainer Gary said...
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.xlsxFri 2 Aug 2013, 16:53Delegate Martin said...
RE: 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
Mon 5 Aug 2013, 13:43Trainer Gary said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
