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 » Summarising data
Summarising data
Resolved · Medium Priority · Version 2010
Thu 13 Oct 2016, 12:27Delegate Daniel said...
Daniel has attended:
Excel Intermediate course
Summarising data
I have multiple data that I wish to turn into a graph/chart for ease of understanding and that I can also use in Powerpoint.
However, presenting this in one chart looks too 'busy' how can I present this in an easy to view fashion?
Thu 13 Oct 2016, 12:52Trainer Jens said...
RE: Summarising data
Hi Daniel,
Thank you for the forum question.
You can try to change the chart type to see if another chart type is more useful for you data or you can instead of having all the data in one chart create a suitable number of charts.
Sometimes changing the value axis can also make a chart easier to understand or working with a secondary value axis for some of the values.
Which solution is the best for you can be difficult to say without looking at your data. If you want me to advise you I will need to see your data.
You can send the workbook to:
info@stl-training.co.uk
Kind regards
Jens Bonde
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
Thu 13 Oct 2016, 14:24Trainer Jens said...
RE: Summarising data
Hi Daniel,
I have received your data, but could you please tell me which range or ranges from sheet 1 you would like to see in the chart.
Thank you.
Kind regards
Jens Bonde
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:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |
