Input to chart 2 column and displayed this values

**mafo** · 01-04-2013, 06:36 AM

Hallo

Please help me.
how I can insert a column "C" in the graph as seen here? Example see attach.

thanks all

mafo

**DBY** · 01-04-2013, 04:26 PM

Hello
Maybe the following formula copied down D2:D6. Then select each individual Data Label and link them in the Formula Bar with '=' to the relevant cell in column D.

=A2&". "&B2&", "&C2

The Data labels would then read 'london. 100, 9' etc. and change with any change of values once linked.

Hope this helps.
DBY

**mafo** · 01-06-2013, 08:34 AM

thanks, but chart is not displayed, chart can not read data

**mafo** · 01-06-2013, 08:48 AM

thanks, but chart is not displayed, chart can not read data

**Palmetto** · 01-06-2013, 09:28 AM

Option 1:
Create a new column(D) with the formula, copied down: =A2&" ("&C2&")"
Set the X-axis labels to column(D) cells: Legend will show text as London (9), Paris (7), etc.

Option 2:
The values in each series (turnover and num) vary widely and are two different metrics. It is best to show them on separate axes or even in two different charts. See if the attached example is something you can use.

Excel forum chart help.xlsx

**DBY** · 01-06-2013, 03:59 PM

Hello
Sorry you're having difficulty making it work. Palmetto has given you two very good options.

See attached reply for my example of Linked Data Labels and Palmetto's suggestion of using the horizontal axis values.

DBY