Weight loss is a common thing in everyone’s life. It becomes easier to understand this loss properly when the use of a graph is effective. You can do this easily by using Excel. By studying how to create a weight loss graph in Excel, you’ll learn the steps and techniques to create a weight loss graph. In this article, we’ll try to discuss the steps of how to create a weight loss graph in Excel.
Download Practice Workbook
3 Steps to Create a Weight Loss Graph in Excel
You need to follow some simple steps in Excel to prepare a weight loss graph. Let’s discuss the steps.
Step 1: Make a Dataset First to Create a Weight Loss Graph in Excel
Firstly, we have to prepare a dataset. The dataset might be based on the title Dataset for Creating a Weight Loss Graph. It includes Date, Measured Weight (lbs), Target Weight (lbs), Target Weight Low (lbs), and Target Weight High (lbs). The dataset is like this.
Suppose you need to lose weight to 160 lbs, which is your Target Weight (lbs). Target Weight Low (lbs) and Target Weight High (lbs) are minimum and maximum weight goals, respectively.
Read More: How to Calculate Weight Gain or Loss in Excel (5 Easy Methods)
- How to Calculate BMI in Excel (2 Handy Ways)
- Weight Loss Spreadsheet in Stones and Pounds (2 Useful Examples)
Step 2: Select the Dataset and Create a Weight Loss Graph in Excel
- In this step, you need to select the cells first that you want to include in your graph.
- So, select the whole dataset.
- Secondly, go to the Insert button > select the Recommended Charts
As a result, an Insert Chart bar will appear like this.
- Thirdly, select any of the chart types you want to use for creating a graph. Then, we have selected the first chart shown in the red below.
- Subsequently, click OK.
- Finally, you’ll get your Weight Loss Graph like this.
Read More: How to Use Formula for Tracking Weight Loss in Excel (2 Examples)
Step 3: Customize the Graph
In this step, you need to customize your chart.
- Firstly, you should add an Axis Title. To do this, click on the “+” sign shown with a red mark > select the Axis Title with a tick mark.
- You can also add any of the elements in the Chart Elements bar according to your requirements.
As a result, space for Axis Title will appear like this.
- Secondly, write Weight in lbs in the vertical Axis Title box and Date in the horizontal Axis Title.
- Finally, you should add your graph title in the Chart Title You can type the Weight Loss Graph in the Chart Title box.
Now, your Weight Loss Graph is ready to use!
Things to Remember
- You need to select the cells first before going to the Insert option. You should avoid selecting cells that have no use in creating graphs.
- You can customize your graph in various ways by selecting from 3 different icons. These icons are shown in the upper right-hand corner of the graph.
- You can create a dataset for a whole year, which will give you a graph of weight loss and tracking throughout the year.
So, I strongly believe you can prepare any kind of weight loss graph after reading this article. Please feel free to visit our official Excel learning platform, ExcelDemy, for further queries.