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.
|Ivory Coast´s tournament starts now - Renard|
|Allegri rejects Juve criticism|
|Atletico´s Arda Turan escapes red card after throwing boot at assistant referee|
|Atletico Madrid 2 Barcelona 3 (agg 2-4): Neymar double secures semi-final spot|
|Parma 0 Juventus 1: Morata late show wins it for visitors|
|Sheffield United 2 Tottenham 2 (agg 2-3): Pochettino books Wembley final|
|Ecuador dismiss Vizuete|
|Championship Preview: Middlesbrough out to continue run, Bournemouth seek response|
|Guinea 1 Mali 1: Lots to decide Group D runners-up|
|Cameroon 0 Ivory Coast 1: Gradel strike sends Renard´s men through|
|Lots to be drawn to decide AFCON qualifiers|
|Eredivisie Preview: De Boer warning for Ajax, leaders PSV host Willem II|
|Bundesliga Preview: Leaders Bayern and Wolfsburg kick off Ruckrunde|
|Howard boost for Everton|
|Ligue 1 Preview: Jardim plays down Monaco title hopes ahead of Lyon showdown|
|Costa charged by FA for alleged Can stamp|
|O´Keefe joins Cardiff|
|Dons teenager Alli in demand|
|Gabriel seals Arsenal switch|
|Wolfsburg v Bayern Munich: Guardiola eyes ´big step´ to Bundesliga title|
|Paris Saint-Germain v Rennes: Montanier seeks another upset in French capital|
|Martinez rules out panic buys|
|Gilardino targets Fiorentina goals|
|Milan agree Bocchetti loan|
|League Two Preview: Cambridge and Luton prepare to renew rivalries|
|Ronaldo hit with two-match ban|
|West Brom complete McManaman deal|
|Sullivan hits back in Sakho row|
|Richards: Cuadrado suited to Premier League|
|Figo to challenge for FIFA presidency|
|Inzaghi out to freshen up struggling Milan|
|Wigan agree a fee for Mckay|
|Carver eyes strong finish|
|Bowen cools talk of Stoke swoop for Sandro and Traore|
|Lazio-bound Morrison lands in Rome|
|Mourinho fined £25k for ´campaign´ claims|
|Mainz bring in Castillo|
|Villa: Lambert will not be sacked|
|Monk hopeful of adding new faces|
|Sainsbury ready to replace Franjic|
|Beckenbauer hopeful of Guardiola stay|
|Mourinho hits back at Costa critics|
|Rodriguez grateful for ´fundamental´ Ronaldo support|
|La Liga Preview: Real want revenge against Socieded|
|No Dallas move for Essien|
|Bale rubbishes United link, Ronaldo rift|
|Sahin in ´good shape´ for Bundesliga resumption|
|Rodgers slams Costa´s stamp collection|
|Under-fire Inzaghi urges patience|
|Rodgers: Courtois saved Chelsea|
|Mashaba wants lessons to be learnt after AFCON exit|
|Mourinho refuses to wade into Costa incidents after Chelsea win|
|Football League Review: Bent double sends Derby second, Rotherham triumph|
|Chelsea 1 Liverpool 0 (aet, agg 2-1): Ivanovic settles action-packed League Cup semi-final|
|Milan 0 Lazio 1: Inzaghi future plunged into further doubt|
|Neymar dreaming of ending Brazil´s home hoodoo|
|South Africa 1 Ghana 2: Late Ayew winner seals qualification|
|Senegal 0 Algeria 2: Mahrez and Bentaleb dump Senegal out|
|Bocchetti poised to join Milan on loan|
|De Rossi suffers calf injury|
|Montano accuses Oldham of double standards after Evans saga|
|Bojan out for the season with ruptured cruciate|
|Cameroon v Ivory Coast: Renard defends Yaya Toure|
|Yanga-Mbiwa makes Roma move permanent|
|Guinea v Mali: Quarter-final berth on offer in Mongomo|
|Thohir: Inter not reliant on European football|
|Bremen land Vestergaard|
|Allegri refuses to rule out Cassano move|
|Mexes handed four-game ban after Lazio dismissal|
|Joyce reveals Valdes´ inspirational team-talk|
|CAF announces AFCON venue switches|
|Alcacer commits future to Valencia|
|Postecoglou calls for Aussie ´energy´|
|Everton confirm Eto´o departure to Sampdoria|
|Pochettino to stick with Vorm despite cup error|
|Barcelona are not favourites against Atletico, says Luis Enrique|
|Allegri wary of Parma backlash in Coppa Italia|
|Zidane urges Real to tie Ancelotti down|
|FIFPro: Transfer system failing football|
|Anderlecht condemn Standard´s Defour banner|
|Australia 2 UAE 0: Socceroos ease into home final|
|Barca overhaul youth system|
|FIFPro demands clubs respect contractual obligations|
|Mahmoud targeting World Cup place with Iraq|
|Fabregas wants Chelsea to show winning mentality|
|Rangers borrow £10m from Ashley´s Sports Direct|
|Lyon face anxious wait over Lacazette|
|Undermanned Lazio recall Perea|
|Ki wants South Korea to prove their superiority|
|Ghana´s Gyan wary of South Africa|
|Mashaba urges South Africa to attack|
|Benitez: Napoli deserved to win|
|Pacos de Ferreira 1 Benfica 0: Leaders fail from the spot|
|Serie A Review: Higuain at the double in controversial Napoli win, Udinese see off Empoli|