Welcome, Guest: Join Kenyans247 Log In!

Stats: 291 Members, 13,306 topics and 65 posts Date:  Monday 26 October 2020 at 06:26 PM
Popular & Trending NewestFeatured Links ClassifiedDirectoryLivescoresLive Kenyan TVLive Kenyan Radio Follow Us Like Us

About Us Terms & Conditions Privacy Policy FAQ's Disclaimer Copyright Contact Us Advertise With Us Download K247 APP Marketplace Moderator Policy We Are Hiring Kenya Radio and TV Stations Listen and Watch Live Letter From the C.E.O Kenya Radio Stations Live Kenya TV Stations Live Kenya - Newspapers and News Sites and popular blog Forum Rules

How to Use Cell Values for Excel Chart Labels

Kenyans247 / Science/Technology / Computers / How to Use Cell Values for Excel Chart Labels

101 people viewed

How To Disable Location Services On Mac How To Renew Savings And Credit Cooperative (sacco) License In Kenya How To Create A Website Contact Form With Google Forms How To Pay For Parking In Nairobi County Via Ussd *235#
(Go Down) (» Reply topic)
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.
kenyans247
kenyans247
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.
kenyans247

The column chart will appear. We want to add data labels to show the change in value for each product compared to last month.

kenyans247

Select the chart, choose the “Chart Elements” option, click the “Data Labels” arrow, and then “More Options.”

kenyans247

Uncheck the “Value” box and check the “Value From Cells” box.

kenyans247

Select cells C2:C6 to use for the data label range and then click the “OK” button.

kenyans247

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.

kenyans247

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.

kenyans247

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.

kenyans247

The value from cell E2 is used for the chart title.

kenyans247

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.

Source https://www.howtogeek.com/509290/how-to-use-cell-values-for-excel-chart-labels/

0 Shares 0 Like •

(» Go Up)

You must Sign in or Sign Up to post content

For you to post content on this website you have to log in or register, it only take few minute to create account

Go Up

Recommended for you

How 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

Currently: 1 guest(s) reading this article

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,

About Us | Terms & Conditions | Privacy Policy | FAQ's | Disclaimer | Copyright | Contact Us | Advertise With Us | Download K247 APP | Marketplace | Moderator Policy | We Are Hiring | Kenya Radio and TV Stations Listen and Watch Live | Letter From the C.E.O | Kenya Radio Stations Live | Kenya TV Stations Live | Kenya - Newspapers and News Sites and popular blog | Forum Rules | Featured LinksFollow Us on TwitterLike Us on Facebook

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.