How can you make one chart look like another?
You have several options.
One option is to copy formatting, and use Paste Special.
First, snag the chart on the left and copy.
Excel will apply formatting from the original chart.
Let’s take a moment to study to review the formatting applied.
First, the font color and size is applied to the entire chart.
Colors were also copied.
Both charts now use the same monochromatic blue palette.
The copy paste operation also affected the position of elements in the chart.
Finally, the chart throw in was also changed.
Before copying formats, the chart on the right was a regular stacked column chart.
Now it’s a 100% stacked column chart, just like the original.
One thing that was not copied is the chart size.
If needed, you’ll need to adjust chart sizes manually to match.
Another way to make one chart look like another is to use a chart template.
We’ll look at that option in a separate video.
