Excel - IF Function Problem - Expert Solution

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

I want my chart to disappear and reappear data on the Y-axis depending on whether there is data entered. For instance, I'm running a chart that has data for Jan-Dec that I want to update every month, but I don't want all months to appear if I haven't updated that month yet
Solved by M. U. in 28 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 13/09/2018 - 06:00
Hello
Excelchat Expert 13/09/2018 - 06:00
welcome to got it pro
User 13/09/2018 - 06:00
Hello
Excelchat Expert 13/09/2018 - 06:00
hi
Excelchat Expert 13/09/2018 - 06:00
may i know how can i help you?
User 13/09/2018 - 06:00
I want my chart to disappear and reappear data on the Y-axis depending on whether there is data entered. For instance, I'm running a chart that has data for Jan-Dec that I want to update every month, but I don't want all months to appear if I haven't updated that month yet
Excelchat Expert 13/09/2018 - 06:01
uhm ok, could i have your file so i can check on it
User 13/09/2018 - 06:02
[Uploaded an Excel file]
Excelchat Expert 13/09/2018 - 06:03
checking on it now
User 13/09/2018 - 06:03
I'm looking at the chart labeled "Certifications by Hire Date Up to Current Month"
User 13/09/2018 - 06:04
You can see I don't have data for Aug-Dec, so I want the chart to automatically hide that
User 13/09/2018 - 06:04
But when I add to it next month, I don't want to have to make adjustments, I just want it to show up if there's data there
Excelchat Expert 13/09/2018 - 06:05
yes im seeing it now
Excelchat Expert 13/09/2018 - 06:06
so you wnt here is not to show the month that was no data right?
User 13/09/2018 - 06:06
correct
Excelchat Expert 13/09/2018 - 06:06
ok
Excelchat Expert 13/09/2018 - 06:07
on the certification chart?
User 13/09/2018 - 06:07
Yes, on both the Certification and the Application by Month, but as long as I know how to apply it to one, I can apply it to the other
Excelchat Expert 13/09/2018 - 06:08
ok, just give me a minute to work on this
User 13/09/2018 - 06:08
Ok thanks
Excelchat Expert 13/09/2018 - 06:11
can you check this one
[Uploaded an Excel file]
Excelchat Expert 13/09/2018 - 06:12
i made a formula on your table
Excelchat Expert 13/09/2018 - 06:13
so if the value was 0 or none, the hire dates will be blank, so it will now show also on your chart
Excelchat Expert 13/09/2018 - 06:14
hello are you still there?
User 13/09/2018 - 06:14
But I'm still seeing the months of August - December show on the chart though
Excelchat Expert 13/09/2018 - 06:15
oh i see, i made fist on the first 2 charts
Excelchat Expert 13/09/2018 - 06:15
on the above
Excelchat Expert 13/09/2018 - 06:15
first*
User 13/09/2018 - 06:16
Oh ok, yeah I want it actually on the bottom 2 because those are by month
Excelchat Expert 13/09/2018 - 06:16
ok im working on it now
User 13/09/2018 - 06:19
I see what you did there though, and it can be applied to the months, I just tested it out, the only issue I have is that there is still a bunch of space still left on the chart, that's why I was hoping this could be some sort of chart setting instead of formula
Excelchat Expert 13/09/2018 - 06:19
yes im donw on it
Excelchat Expert 13/09/2018 - 06:19
done*
Excelchat Expert 13/09/2018 - 06:19
here you go
[Uploaded an Excel file]
Excelchat Expert 13/09/2018 - 06:21
is it what you are looking?
User 13/09/2018 - 06:21
still though the only issue I have is that there is still a bunch of space still left on the chart, that's why I was hoping this could be some sort of chart setting instead of formula
Excelchat Expert 13/09/2018 - 06:23
our chart is on the table, there's no way to remove those month on the chart
Excelchat Expert 13/09/2018 - 06:23
only the way we do
Excelchat Expert 13/09/2018 - 06:24
unless we do revise our table
User 13/09/2018 - 06:25
ok, that's what I was afraid of, this is the 2nd best option though thanks!
Excelchat Expert 13/09/2018 - 06:25
you welcome,
Excelchat Expert 13/09/2018 - 06:25
Is there anything else I can help you with?
User 13/09/2018 - 06:25
that's it, thank you
Excelchat Expert 13/09/2018 - 06:26
oh ok
Excelchat Expert 13/09/2018 - 06:26
thanks, by the way could I ask your kind feedback after our session?
User 13/09/2018 - 06:27
sure
Excelchat Expert 13/09/2018 - 06:27
thanks so much :)
Excelchat Expert 13/09/2018 - 06:27
you can end now our session by clicking the end button on the upper right

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.