Trend Graph to show % and numbers

**Vinod Krishna.C** · 08-04-2020, 01:14 AM

Hi team,

We have a monthly data for which we are calculating Change and %Change

We have a requirement to create a trend graph to show both % along with numbers. PFA for the current state of our solution.

Need your help in getting the numbers next to % values in the graph as in the attached screenshot.

Thanks,
Vinod Krishna

**Andy Pope** · 08-04-2020, 02:19 AM

You can build the data label text using a formula

=TEXT(G3,"0%") & " (" &G2 &")"

Drag that across to create the 3 text for the 3 data labels.
The format the data labels to use Values from Cells

Trend Graph to show % and numbers

LinkBack

Thread Tools

Rate This Thread

Display

Trend Graph to show % and numbers

Re: Trend Graph to show % and numbers

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Graph Pairs from 3digit numbers sorted to show a trend or sequence

Help with Graph to show Hours Trend

[SOLVED] How to group numbers together and produce a graph to show this in Excel.

Excel graph won't show negative numbers?

How do I show break in bar graph to show large and small numbers

How do I show break in bar graph to show large and small numbers

[SOLVED] How do I show negative numbers on a stacked graph

Bookmarks

Bookmarks

Posting Permissions