Two dreadful errors ended Real Madrid's slim hopes of winning the Liga title as Celta Vigo claimed a shock 2-0 victory on Sunday.
Back-to-back draws with Valencia and Real Valladolid left Madrid needing to win their two remaining fixtures and hope that Atletico - with a better head-to-head record against their city rivals - slipped up in both of theirs.
But despite Atletico only drawing at home to Malaga, Carlo Ancelotti's men are now out of the running after failing to do their part.
Real's defenders were their chief culprits, as mistakes from Sergio Ramos and Marcelo helped Charles to perhaps the simplest double of his career.
All eyes will now turn to the Camp Nou, where defending champions Barcelona will host Atletico in a mouth-watering championship decider next weekend.
Barcelona, who are three points adrift in second, will win the league with a victory while Atletico need only to avoid defeat.
Real were hampered from the off, with a thigh injury ensuring that Cristiano Ronaldo could not even take a place on the bench.
Fellow big-money recruit Gareth Bale was among the substitutes, while Sami Khedira started a game for the first time since damaging knee ligaments in November.
It was the visitors who started on the front foot, their first opening coming when Marcelo's powerful half-volley was deflected just wide.
But Celta began to press thereafter, with Fabian Orellana looking particularly threatening.
Ancelotti's side defended impressively to weather that spell without giving up any real chances and gradually began to impose their will on the game.
Their attacking intent almost led to an opener in the 35th minute, Isco forcing a superb reaction save from Sergio Alvarez with a low effort.
Another chance went begging when Alvaro Morata fired Marcelo's low cross wide - and Real were left to rue their profligacy as the home side took the lead three minutes before the break.
Ramos was the culprit, his slip leaving Charles to round Diego Lopez and slide the ball into the empty net from a tight angle.
As expected, Real came out positively after the break and almost levelled matters when Luka Modric shot over in the process of being brought down in the area by Jon Aurtenetxe, the referee turning down strong penalty appeals.
Undeterred, the visitors pressed forward further, with Morata and Isco again testing Alvarez.
But the latter's chance, in which he shot straight at the goalkeeper, prompted an immediate reply as Celta increased their lead.
Marcelo was at fault this time, selling Lopez short with an awful back-pass that allowed Charles to nip in and grab his second.
Real pushed desperately to get back into it late on, but the inspired Alvarez combined with some dogged defending to keep them out.
|Pochettino: No issue with Conte ahead of London derby|
|Bonucci not crucial like Maradona, Messi or Ronaldo - Barzagli|
|Chelsea are still title favourites - Mourinho cranks up mind games with former club|
|Jardim lauds record-breaking Monaco|
|Ancelotti wants Bayern improvement despite opening Bundesliga win|
|We need time - Conte calls for patience in pursuit of long-term Chelsea success|
|Valencia sign defender Murillo from Inter|
|Burton Albion 2 Birmingham City 1: Sordell and Dyer spark second-half comeback|
|Bayern Munich 3 Bayer Leverkusen 1: Debutants Sule and Tolisso net in rain-lashed Bundesliga opener|
|Metz 0 Monaco 1: Falcao´s late winner seals record-breaking victory|
|Is Sanchez another Sissoko? Tottenham record signings haven´t always fared well|
|Barcelona to wear commemorative shirts in tribute to victims of attacks|
|Sanchez joins Mendy, Bonucci and Luiz on list of world´s most expensive defenders|
|Matuidi delighted to follow French legends Zidane, Platini and Deschamps to Juventus|
|West Ham give Reid six-year contract|
|Roma and Inter competing for Sampdoria forward Schick|
|UEFA charge Hajduk Split and Everton|
|Fiorentina loan Pezzella from Real Betis|
|Sanchez joins Tottenham in club-record deal from Ajax|
|Draxler not trying to leave PSG after Neymar arrival, says agent|
|Valencia complete deal for Arsenal defender Gabriel|
|Matuidi seals €20m Juventus move|
|Bellamy backs Coutinho´s Barcelona wish as Liverpool reportedly reject new £114m bid|
|Rooney deserves more credit, says record Everton signing Sigurdsson|
|Allegri challenges Dybala: I want an extraordinary season|
|Boateng completes Frankfurt move|
|Burke one of many Crystal Palace targets, reveals De Boer|
|Keizer expects Tottenham target Sanchez to leave Ajax|
|Guardiola offers sympathies to ´beautiful´ Barcelona|
|Neymar ´one more player´ for PSG boss Emery|
|Chelsea boss Conte envious of Tottenham´s foundation|
|Evans is a West Brom player - No transfer plea from Man City boss Guardiola|
|Bakayoko in contention for hasty Chelsea debut at Spurs|
|Manchester United are no dream team, warns Mourinho|
|Jose Mourinho accepts defeat in hunt for fourth Manchester United signing|
|Pochettino wants four Tottenham signings before transfer window closes|
|Kayode loaned to Girona after joining Manchester City|
|Conte bursts out laughing over Costa´s ´criminal´ treatment claim|
|Costa: Chelsea return would not be fair situation|
|Juventus boss Allegri sees ´five or six´ teams in Scudetto race|
|Barcelona, Real Madrid hold minute´s silence for Las Ramblas victims|
|Diego Costa is not an Atletico player - Simeone unmoved on Chelsea star|
|Costa accuses Chelsea of pricing him out of Atletico Madrid move|
|Armstrong signs new Cetlic deal to end speculation|
|Serie A 2017-18: Ambitious AC Milan set sights on Juventus dominance|
|Frankfurt medical for Boateng after Las Palmas exit|
|Castro shocked by Dembele as Dortmund star pushes for Barcelona move|
|Defoe pushing for start against Watford|
|Jese Rodriguez set to make Stoke debut against Arsenal|
|West Brom don´t need to sell Evans - Pulis responds to Manchester City bid|
|Matic in Chelsea dig: Manchester United are definitely bigger|
|Serie A 2017-18: Shock signing Bonucci, Juve star Dybala - five stars to watch|
|Bilic ´sure´ Liverpool target Lanzini is staying at West Ham|
|Bailly: Manchester United will prove world-class status this season|
|Klopp: No reason to leave Liverpool as Barca eye Coutinho|
|Montella happy with Milan progress|
|United signing Matic from Chelsea a masterstroke - Robson|
|Milan in ´advanced´ talks to sign Kalinic, Fassone tight-lipped on Ibrahimovic|
|Barcelona to honour terror victims in LaLiga opener|
|Europa League Review: AC Milan on fire, Athletic Bilbao in stirring comeback and Fenerbahce suffer s|
|We were lucky - Koeman frustrated by Everton´s second-half struggle|
|Bonucci revels in ´wonderful´ San Siro bow as AC Milan destroy Shkendija|
|Everton 2 Hajduk Split 0: Keane opens account in comfortable Europa League win|
|AC Milan hit 24-year high in Shkendija thrashing|
|AC Milan 6 Shkendija 0: Silva, Montolivo inspire Rossoneri to brink of Europa League group stage|
|Messi, Ronaldo and Suarez lead tributes as football stands with Barcelona|
|Usain Bolt offered burgers and beer to join Portuguese football club|
|Hummels joins Mata in pledging one per cent of his wages to charity|
|Carroll poised for West Ham return at Newcastle|
|Arsenal´s Alexis Sanchez named in latest Chile squad|
|Ruben Yanez joins Getafe from Real Madrid|
|Clement: Swansea can be stronger without Sigurdsson|
|Paulinho insists he can fit in at Bacelona|
|Gabi urges Costa to respect Chelsea despite desire to join Atletico Madrid|
|Mbappe left out of Monaco squad amid ongoing PSG links|
|Zidane, Mourinho, Low, Conte and Guardiola to battle for Best FIFA Men´s Coach prize|
|Bosz has ´no idea´ whether Dembele will stay at Dortmund|
|Messi, Ronaldo, Iniesta and Kane among nominees for Best FIFA Men´s Player award|
|Messi not signing new deal would surprise Barcelona VP Mestre|
|Barca in ´difficult situation´ over Coutinho and Dembele|
|Sturridge fit for Palace clash|
|LaLiga 2017-18: Messi in transition, Bale battling for his place - five stars to watch|
|Nothing has changed over Coutinho - Klopp|
|Barcelona´s Luis Suarez to miss four to five weeks with knee injury|
|James one of six Bayern stars out of Bundesliga opener|
|Tottenham midfielder Sissoko: No agreement with any club|
|Barca ´not a millimetre closer´ to signing Dembele - Watzke|
|Neymar money would fund us for ´15 years´, says Toulouse boss|
|Transfer market is crazy, admits £45m Everton new boy Sigurdsson|
|Barcelona complete €40m Paulinho signing from Guangzhou|
|LaLiga 2017-18: Madrid ready to tighten grip on bumbling Barcelona|
|Brighton tie Knockaert, Dunk & Duffy to new deals|
|Milan ready to fight for Scudetto - Kaka|
|Bundesliga 2017-18: Ancelotti angst, Bosz bottle and VAR all under scrutiny as new season kicks off|
|Carvajal: Real Madrid were all over Barcelona|
|Bundesliga 2017-18: James checks in as Aubameyang stays – five stars to watch|
|Behrami leaves Watford for Udinese|
|Wenger and Arsenal willing to make financial sacrifice on Sanchez|
|Montreal Impact 3 Chicago Fire 0: Piatti double sinks slumping visitors|
|Pique: This is the first time I´ve felt inferior to Real Madrid|
|Asensio: Madrid played better and deserved Supercopa title|
|Barca star Suarez to undergo tests on knee injury|
|Barca close to signing Coutinho and Dembele - Segura|
|Valverde: Madrid aren´t invincible as Barca boss laments Neymar loss|
|Zidane lauds ´spectacular´ Madrid after Supercopa triumph|
|PSG troll Barcelona over Supercopa loss to Madrid|
|Real Madrid 2 Barcelona 0 (5-1 agg): First-half Barca failings settle Supercopa|
|Champions League Review: Mertens stars as Napoli put two past Nice|
|Rodgers eyes Liverpool reunion after ´perfect´ Celtic hammer Astana|
|Demebele can´t just do whatever he wants - Dortmund team-mate Sokratis|
|Championship Review: Norwich off the mark, Sheffield Wednesday hold Sunderland|