How to Left Align a Chart in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Charts are very important tools to visualize and represent data attractively. While working with Excel charts, sometimes you need to Align the charts in Left, Right, or Center positions. Aligning a chart is a very easy process in Excel. In this article, I would like to show you how to left align a chart in Excel with 2 simple steps and necessary illustrations. I hope you will enjoy the process and can develop your Excel skills.


How to Left Align a Chart in Excel: Easy Steps

Let’s consider a dataset of Product Sales of ABC Company. The dataset has two columns B and C representing Product Code and Sales Amount. The dataset ranges from B4 to C9 cells. From here, I will explain how to left align a chart in Excel with the necessary steps and illustrations.

dataset of how to left align a chart in excel


Step 1: Insert a Scattered Chart

  • First, Select the whole dataset.
  • Then, Go to the Insert tab in your Toolbar.
  • After that, Select the Scattered Chart
  • Hence, Select the second option.

Inserting a Scattered Chart to left align a chart in excel

  • Consequently, you will get the chart just like the picture given below.

Inserting a Scattered Chart to left align a chart in excel


Step 2: Align Chart on the Left Side

  • Select the chart first.
  • After that, you will find 8 points around the chart.
  • Select any of the three indicated points.
  • Then, Drag any of these three points.

left align a chart in excel

  • As a result, you will find the newly aligned chart.

left align a chart in excel

  • You can also align two charts on the left side. First, apart from the scattered chart, Select the whole data table to insert a pie chart.
  • After that, Go to the Insert tab in your Toolbar.
  • Then, Select the Pie Chart.
  • Hence, Select the 3-D Pie.

left align two chart in excel

  • As a consequence, You will find the pie chart like the picture given below.
  • You will see that the pie chart is slightly displaced from the scattered chart on the right side.

left align two chart in excel

  • To solve this problem, first, Select a chart.
  • After that, Select another chart by pressing the Shift.

  • After that, Go to the Shape Format option in your Toolbar.
  • Moreover, Select the Align.
  • Then, Press the Align Left.

  • As a result, you will find both of the charts are perfectly aligned on the left side.

Read More: How to Center a Chart in Excel


Things to Remember

  • In step 1, we dragged the chart manually. If we want to put the chart’s corner on a cell’s corner, we need to drag and press the Alt key simultaneously.

Download Practice Workbook

Download the practice workbook to practice yourself.


Conclusion

In this article, I have tried to explain how to left align a chart in Excel. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles


<< Go Back to Formatting Chart in Excel | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Souptik Roy
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo