Popular & Trending •
Live Kenyan TV •
Live Kenyan Radio
Follow Us Like Us
How to Use Cell Values for Excel Chart Labels
101 people viewed
|How to Use Cell Values for Excel Chart Labels by Kenyans247(1): Mon 16, March, 2020 04:36pm|
Make your chart labels in Microsoft Excel dynamic by linking them to cell values. When the data changes, the chart labels automatically update. In this article, we explore how to make both your chart title and the chart data labels dynamic.
We have the sample data below with product sales and the difference in last month’s sales.
We want to chart the sales values and use the change values for data labels.
Use Cell Values for Chart Data Labels
Select range A1:B6 and click Insert > Insert Column or Bar Chart > Clustered Column.
The column chart will appear. We want to add data labels to show the change in value for each product compared to last month.
Select the chart, choose the “Chart Elements” option, click the “Data Labels” arrow, and then “More Options.”
Uncheck the “Value” box and check the “Value From Cells” box.
Select cells C2:C6 to use for the data label range and then click the “OK” button.
The values from these cells are now used for the chart data labels. If these cell values change, then the chart labels will automatically update.
Link a Chart Title to a Cell Value
In addition to the data labels, we want to link the chart title to a cell value to get something more creative and dynamic. We will begin by creating a useful chart title in a cell. We want to show the total sales in the chart title.
In cell E2, enter the following formula:
="Monthly Sales Total - "&TEXT(SUM(B2:B6),"0,###")
This formula creates a useful title that combines the text “Monthly Sales Total – ” to the sum of values B2:B6.
The TEXT function is used to format the number with a thousand separator.
We now need to link the chart title to cell E2 to use this text we’ve created.
Click the chart title, enter = into the Formula Bar, and then click cell E2. From there, press the Enter key.
The value from cell E2 is used for the chart title.
If the values in the data range were to change, our data labels and chart title would update to reflect that on the chart.
Using creative and dynamic labels for your charts, by basing them on cell values, will take your charts beyond the standard charts others create in Excel.
0 Shares 0 Like •
For you to post content on this website you have to log in or register, it only take few minute to create account
Recommended for youHow To Make Payments Using Safaricom M-pesa 1tap How To Register As A Contractor In Kenya How To Turn On Two-factor Authentication In Slack How To Apply For A Prescribed Profession Permit In Kenya
Sections: Diaspora, Career, Business, Agriculture, K247 Intelligence, Building/Architecture, Computers, Education, Universities, Webmasters, Forum Games, Sports, Photography, Celebrities, Theatre/Comedy, South Sudan Forum, Somalia Forum, Tanzania Forum, Rwanda Forum, Burundi Forum,
Kenyans247 - Copyright © 2019 - 2020 Sande Kennedy. All rights reserved. See How To Advertise.
Disclaimer: Every Kenyans247 member is solely responsible for anything that he/she posts or uploads on Kenyans247.