How to align chart with cell grid
This trick is so simple and also an incredible time-saver if you want to build beautiful worksheets or dashboards where charts and data live happily together.
Begin selecting the chart you want to align.
The dots surrounding the chart allow you to resize the chart as you please.
Simply press and hold on one of these dots with left mouse button, then press the Alt key while you drag the dot.
This will snap the dot to a grid line, if you are not happy with the location simply drag the dot to the line you want to align.
Repeat above step with the remaining three chart corner dots.
Remember that if you resize columns or rows the chart will follow and resize automatically.
Chart basics category
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
Fatou asks: Going back to my question, I had created a table and used the data to create a chart. […]
The image above shows lines between each colored column, here is how to add them automatically to your chart. Select […]
Charts category
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above […]
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.