← Back to Plaza
Como construir un GRÁFICO DINÁMICO con Doble Eje. Así se realiza un G...
TikTok

Como construir un GRÁFICO DINÁMICO con Doble Eje. Así se realiza un G...

67k views·May 12, 2026
Open original video ↗

Transcript

0:00this graph
0:00in excel makes your reports look pro in seconds
0:03in this case
0:04I have a table of
0:05the sale
0:05of products where you can see the complete video
0:09you may not find it later
0:11select
0:12one of the arrows in this table and I am on my way to insert
0:16then I turn to graph
0:19existing framework
0:21for
0:21insert the attached graphic in a sheet that I have already created
0:25select for example here
0:27press enter
0:29press accept and automatically
0:31I have the dynamic table and the graph too
0:35on the right side the fields are enabled
0:38I will add for example product in axes and in values
0:42I add amount and add income
0:45and automatically
0:46the dynamic table and the three-dimensional graph are being built
0:50I am going to
0:51the names and in row label I will consider products
0:55I will adjust the width of the columns
0:58and this is the graph
1:01I keep this chart selected
1:03right click press
1:05press change graphic type
1:07and I get this floating picture
1:10I turn to combined graphic at the bottom
1:13this first graph
1:14and here is a sample of the graph
1:17and in
1:17the bottom part shows the two value variables
1:21amount e
1:22and on this right side I see the secondary axis
1:25in this case I will decline in income
1:28and as you can see
1:29appears in this way and this was added to the secondary axis
1:33then change the chart types
1:35in this case I am going to leave it as is
1:38in the case of income I will correct this graph
1:41then press accept
1:44I keep the chart selected
1:46and I turn to graph analysis.
1:49and deactivate the buttons
1:51now the buttons are no longer shown in the graph
1:54this legend
1:55I am going to change it and put it at the bottom.
1:59I adjust the size of the graph
2:02then I add the axis title and the graph titles
2:06graphic title
2:07I will consider sales by product
2:11of the bottom shaft
2:12left side shaft products
2:15amounts the shaft on the right side income
2:19I continue to adjust the size of the graph
2:22and there is the left graphic
2:24I will also add the data labels
2:27and I will change the width of the bars
2:30I select these bars on the right side here I write
2:34fifty
2:36and select the labels on the bars
2:39in label format
2:41frame this symbol and in position
2:43center frame
2:45saw that the position of the labels has now changed
2:48I am going to put it in bold
2:50and white color
2:52I can also change the color of these bars
2:55I'm going to paint a darker color
2:57I will also change the line labels
3:00or income
3:02I select these labels
3:04and I turn to tag format
3:06select this symbol in the position above
3:10and I'm going to change it color
3:12and also in bold
3:13to prevent the labels and values from being displayed
3:16in this way
3:17I select these values
3:19and I will change the format
3:22then I go on to analyze the whole dynamic
3:25then to insert time scale
3:28date frame accept
3:31and this time scale is added
3:34here for example
3:35I can select one month on time
3:37or I can see an accumulated
3:40it's that simple and fast you'll be able to
3:42build a three-dimensional graphic

Mind Map

Loading mind map…

Viral Breakdown

Hook (first 3 seconds)

  • Verbatim opening line: "this graph in excel makes your reports look pro in seconds"
  • Hook pattern: Bold claim + benefit promise (pro results in seconds)
  • Why it stops scroll: Instantly promises a high-value, low-effort outcome — “pro in seconds” triggers FOMO for anyone who uses Excel at work. The specificity (“this graph in excel”) signals a tutorial, not fluff.

Emotional Rhythm

  1. Curiosity — “makes your reports look pro in seconds” (viewer wants to know how)
  2. Tension — The step-by-step instruction builds urgency: “you may not find it later”
  3. Frustration relief — “automatically I have the dynamic table and the graph too” — payoff for following along
  4. Satisfaction — “select for example here press enter press accept” — quick clicks confirm ease
  5. Pride / mastery — “I will adjust the width of the columns and this is the graph” — viewer feels they can replicate
  6. Climax moment — The 3D graph appears and the time scale is added — “it's that simple and fast” — final emotional payoff of competence

Keyword Density

  • graph (15+ times) — algorithmic reach: high-volume search term in productivity/Excel content
  • dynamic table (5 times) — algorithmic: niche but high-intent keyword for Excel power users
  • income / amount / product (repeated across steps) — emotional pull: relatable business context
  • change / adjust / select (frequent action verbs) — emotional: creates a sense of control and step-by-step mastery
  • right click / press accept / insert (procedural phrases) — algorithmic: triggers YouTube/Shorts search for “Excel tutorial”
  • simple and fast (closing line) — emotional: reinforces the core benefit, drives retention

Why It Spreads

  1. Universal pain point, instant solution — The opening line directly addresses a common frustration (“reports look amateur”) and promises a fix in seconds. Transcript evidence: “this graph in excel makes your reports look pro in seconds”
  2. High replay value for learners — The dense step-by-step format forces viewers to rewatch or pause, increasing watch time and retention. Transcript evidence: “select one of the arrows … then I turn to graph existing framework … press accept”
  3. Algorithmic keyword stacking — Every few seconds, a high-search-volume term like “graph,” “dynamic table,” “change graphic type,” “secondary axis” appears, boosting discoverability. Transcript evidence: “I turn to combined graphic … secondary axis … change the chart types”
  4. Actionable visual payoff — The video ends with a polished 3D graph, giving viewers a concrete result they want to show off. Transcript evidence: “this time scale is added … you'll be able to build a three-dimensional graphic”
  5. “I can do that” confidence — The creator’s calm, methodical pace and repeated “select/press/accept” make the task feel achievable, reducing friction to try. Transcript evidence: “I will adjust the width of the columns and this is the graph”

What You Can Steal

  1. Open with a specific, high-value outcome — Start your video with “This [thing] makes your [result] in [time unit].” Example: “This Excel trick makes your monthly report look pro in 30 seconds.”
  2. Weave in 3–5 high-search keywords naturally — Before filming, list 5 terms your target audience searches (e.g., “dynamic table,” “secondary axis,” “3D graph”) and say them aloud during the tutorial. This boosts algorithmic reach without keyword stuffing.
  3. End with a visible, shareable result — The final frame must be a polished output (a graph, a design, a dashboard) that viewers want to screenshot or share. Say “It’s that simple and fast” right before the reveal to lock in the emotional payoff.
Keep exploring

More viral transcripts on Plaza

Drag to browse, or open one to see the full transcript and AI breakdown. Browse all on Plaza →