Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
The moment you are reading this post you still have to explore a lot of things about excel charts unless you are “Jon Peltier“.
Here in this post, I’ll show you 10 charting tips which you can instantly use while creating your next chart.
I’m pretty sure that these charting tips will help you to create charts in a smart way.
10 Charting Tips
If you love to use line chart then you are awesome but it would be more awesome if you use a smooth line in the chart.
This will give a smart look to your chart.
Here are the steps you have to do.
This charting tip is a game changer, I’m telling you.
Let’s say you have to create 10 charts with the same formatting. What will you do?
Format each chart one by one.
No, all you have to do just copy & paste formatting from one chart to another.
Here are the steps.
Now, life is much easier.
This charting tip is simple but still quite useful.
If you don’t want to show axis label values in your chart you can delete them.
But the better way is to hide them instead of deleting.
Here are the steps.
And, again if you want to show it then just select “Next to axis”.
If you are dealing with the large number in your excel chart, you can change the units for your axis values.
Here are the steps to follow.
This will help your users to understand the chart quickly.
I often use excel charts with rounded corners.
And, If you like to use round corners in your chart, follow these simple steps.
This tip is a pro charting tip.
Let’s say if you have a chart with monthly sales in which Jun has no amount & cell is empty.
You can use following options for that empty cell.
Here are the steps to use these options.
Make sure to use “Connect data points with the line” (recommended).
Yes, you can insert a picture in a chart.
It has a limited use but it’s pretty cool to use an image in your chart.
Here I’m using a bar chart to add an image and the steps are.
Learn more about creating pictograph in excel.
This is also a time saver tip.
Let’s say if you have a favorite chart formatting which you want to apply every time you create a new chart.
You can create a chart template to use it anytime in future.
Steps are as follow.
Again, an insane time saver charting tip.
We can use a shortcut key to insert a chart but the problem is, it will only insert the default chart.
And in excel, our default chart type is “Column Chart”.
So, if your favorite chart is line chart, then the shortcuts is useless for you.
But let’s conquer this problem. All you have to do, change your default chart & here are the steps.
Now, you can insert your favorite chart with the shortcut key.
When you hide a cell from the data range of your chart, it will also hide from the chart as well.
And, if you want not to hide data values from your chart even a cell is hidden, just follow these steps.
Now, your chart will remain same even if any from your data range is hidden.
All the tips which I have given above are simple, easy, & tiny but they can make a difference in your charting skills.
Most of these are one time set-ups.
I hope you found them useful.
Have you ever used any option from above?
Or, if you have any other charting tips please share with me, I would love to hear from you.