Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hello, I would like to have my graph automatically updated, but not to extend my graph. For instance, I have created a chart showing some data from 1 Jan to 31 Jan 2018. Now, I have to make charts every month, and I wonder if there is any way that the graph updates automatically without having to manually change the range of my chart.
Solved by A. F. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/03/2018 - 10:28
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern.
Excelchat Expert 18/03/2018 - 10:29
For the charts to automatically update, you have to use pivot table as the source data of your chart
Excelchat Expert 18/03/2018 - 10:30
with that, once you refresh your pivot table or change the month range, your Chart will also be updated with the new data
Excelchat Expert 18/03/2018 - 10:30
Do you have any questions regarding the solution provided?
User 18/03/2018 - 10:30
How do I change the month range from pivot?
User 18/03/2018 - 10:31
Would you mind showing me a demonstration real quick if possible?
Excelchat Expert 18/03/2018 - 10:31
Sure, do you have a sample data that we can use?
User 18/03/2018 - 10:32
no unfortunately
User 18/03/2018 - 10:32
the data I am working on is confidential
Excelchat Expert 18/03/2018 - 10:32
no worries
User 18/03/2018 - 10:34
okay
Excelchat Expert 18/03/2018 - 10:34
ok, I created a Pivot table on the next tab
User 18/03/2018 - 10:35
If i were to create monthly chart and to change it automatically. what should I do?
Excelchat Expert 18/03/2018 - 10:35
ok to do that we have to add another field first to get the month
Excelchat Expert 18/03/2018 - 10:36
from the dates
User 18/03/2018 - 10:36
ok
Excelchat Expert 18/03/2018 - 10:36
ok in column H, I created a formula to extract the month
Excelchat Expert 18/03/2018 - 10:36
=text(A2,"mmm")
Excelchat Expert 18/03/2018 - 10:36
then you need to create a pivot table
Excelchat Expert 18/03/2018 - 10:38
the pivot table would be the source of your chart
User 18/03/2018 - 10:38
okay
Excelchat Expert 18/03/2018 - 10:38
to do that, just highlight the pivot table, then insert chart
Excelchat Expert 18/03/2018 - 10:39
here's a sample chart
User 18/03/2018 - 10:39
yep
Excelchat Expert 18/03/2018 - 10:40
once you add data to your list, you just have to refresh the pivot chart
Excelchat Expert 18/03/2018 - 10:40
let me show you
User 18/03/2018 - 10:42
I would like my chart to show a daily flow
User 18/03/2018 - 10:42
not by monthly
User 18/03/2018 - 10:42
is it possible?
Excelchat Expert 18/03/2018 - 10:42
ok just change the month to days
Excelchat Expert 18/03/2018 - 10:42
yes
Excelchat Expert 18/03/2018 - 10:42
if you click on pivot table,
Excelchat Expert 18/03/2018 - 10:43
you can see pivot table editor at the left side, you can drag and drop the details you want to show there
Excelchat Expert 18/03/2018 - 10:45
I will show you a sample in excel as it is a bit different here in google sheet
User 18/03/2018 - 10:45
ok
Excelchat Expert 18/03/2018 - 10:49
Here's a sample file
User 18/03/2018 - 10:50
opened
Excelchat Expert 18/03/2018 - 10:50
Are you satisfied with the solution provided?
User 18/03/2018 - 10:51
Yeah, I hope to figure it out with the spreadsheet I have. Thank you for your help.
Excelchat Expert 18/03/2018 - 10:51
If you choose only Jan-Feb on months filter, the graph would automatically show just Jan to Feb
Excelchat Expert 18/03/2018 - 10:51
you're welcome
Excelchat Expert 18/03/2018 - 10:51
Excelchat Expert 18/03/2018 - 10:52
Thanks for using Got It Pro-Excel. Please give your kind feedback for our service. Have a good day! :)
User 18/03/2018 - 10:52
ok thank you
Excelchat Expert 18/03/2018 - 10:55
Feel free to end this session as soon as you are ready for us to continue helping other customers. Thank you.
Excelchat Expert 18/03/2018 - 11:02
Hello, if you are still there, kindly end this session so we can continue helping other customers.. Thank you

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.