Make a 12-Month Update Chart in Excel with OFFSET and COUNTA 🔥 [VIEWER QUESTION]
⚡JOIN for early access to weekly tutorials / @spotlightimpact
Thanks again Kate for your follow up question about making a chart in Excel that updates with the last 12 months of data entered. In the last video we used the OFFSET function and the COUNT function to spill the last 12 months worth of data into a data range to create a chart that updates automatically. Since we were using cells formatted with numeric values, the COUNT function worked well, but if you're using cells with Text in them you'll want to use the COUNTA function. I hope this helps, let me know if it does in the comments below!
▶️ Here's our first video on making the chart using OFFSET and COUNT
• How to Make a 12-Month Tracking Chart in M...
▶️ If you want to protect cells so nobody else can make updates try this! • How to Protect a Range of Cells in Microso...
💻 DOWNLOADS FOR PURCHASE
Zip Code Lookup Template [Excel] https://spotlightimpact.gumroad.com/l...
Square Carousel Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
10 Minute Timer Slide Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Net Promoter Slider Chart Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
Waffle Chart Template [Excel] https://spotlightimpact.gumroad.com/l...
Data Placemat or Dashboard Template [PowerPoint] https://spotlightimpact.gumroad.com/l...
🙏 SUPPORT MY CHANNEL
SUBSCRIBE to this channel for more tips, tricks, and tutorials! / @spotlightimpact
JOIN Spotlight Super Fans for early access to weekly tutorials / @spotlightimpact
HIT the SUPER THANKS 💗 button on any video!
DOWNLOAD templates from on Gumroad https://spotlightimpact.gumroad.com/
DOWNLOAD templates from Payhip https://payhip.com/spotlightimpact
BUY stickers, I 💗 CHARTS! https://www.chartheart.com
🎒 COURSES & TRAINING AFFILIATES
Depict Data Studio Courses https://depictdatastudio.teachable.co...
Excel University https://affiliate.excel-university.co...
🙋FAQs
I’m using Microsoft 365 in my videos: PowerPoint, Excel, Word. If you don't have a feature you see here, check the Microsoft support pages for a version feature list
https://support.microsoft.com/en-us
Buying courses through affiliate links above costs no extra, but gives a small percentage of the proceeds to my channel.
#excel #offset #counta