98.8% 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 » Charts
Charts
Resolved · Medium Priority · Version 2016
Thu 1 Aug 2019, 10:11Delegate Franco said...
Franco has attended:
Excel Intermediate course
Mentoring course
Charts
Hi
How do I covert a series of dates into a chart please?
Thank you
Franco
Fri 2 Aug 2019, 10:49Trainer Claire said...
RE: Charts
Hi Franco,
Firstly, make sure your data is tidy. So have your date and the value associated with your date so it's something like this:
02/08/2019 15
03/08/2019 17
04/08/2019 10
05/08/2019 13
06/08/2019 15
07/08/2019 19
Click into the data range and use the shortcut Alt + F1.
This will create a chart from the selected data. It will always be a column chart.
From there you can change the chart layout details from the controls on the ribbon.
Hope this helps.
Claire
Fri 2 Aug 2019, 10:54Delegate Franco said...
RE: Charts
Thanks Claire,
I presume the vale you have at the end of each date is how many tenancies expire on that date. If so, that's where I am stuck. Is there a simple way that Excel can add these up? Once I have this, I can see and am confident enough to know how to convert the data in to a chart.
Kind regards,
Franco
Fri 2 Aug 2019, 11:10Trainer Claire said...
RE: Charts
Hi Franco,
For this example the value next to each date is just an example. In the real world it could mean anything.
You can add any set of values up. The easiest way to do this is to use auto sum. This would be using the formulas that you coverd in Excel intermediate.
Claire
Fri 2 Aug 2019, 11:16Delegate Franco said...
RE: Charts
Hi Claire,
This doesn't help me at all I'm afraid.
I know how to use autosum but what I am struggling with is how can I use the series of dates to know how many have the same month. Once I have that value, I can then create a chart to see visually how many are in each month,
It's hard to explain in an email but I thought I did earlier in my response to Jens.
Franco
Fri 2 Aug 2019, 12:17Trainer Claire said...
RE: Charts
Hi Franco,
You don't need to add them up. Excel will do that for you.
Here is some example data:
01/08/2019 10
01/08/2019 5
01/08/2019 2
02/08/2019 13
03/08/2019 7
03/08/2019 6
If you chart this then excel will add together the values for the same dates.
thanks
Claire
Attached files...
chartexample.xlsx
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:How to Remove Duplication's from a selection of data in an Excel 2010 WorksheetIt would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:- |
