Chart for merged cells as source data

[luctue]

Hi,
I am trying to make a chart with source data that is available in a
range of merged cells (e.g. Value 1 is in the merged cells B1 to J1,
Value 2 in K1 to S1 etc.).
The result is a chart with many steps on the x-axis (B1, C1, D1, E1,
F1, etc.) with a value on every ninth step. How do I merge the steps
on the x-axis in order to have a fluent chart instead of a value every
ninth step?
I hope I made myself clear. Thanks in advance!

 

[moily]

For an already created chart:

Right click on the chart
Choose 'source data'
Choose the 'Data Range' tab
In the 'Data Range' box you'll see something like:
=Sheet1!$B$1:$J$1,Sheet1!$K$1:$S$1
Delete the colons and the bits after them before each comma so that it
should look something like: =Sheet1!$B$1,Sheet1!$K$1

For a chart to be created:

Hold down Ctrl and click on the first cell of each merged data set (so if
the first data set is B1:J1 and second set is K1:S1 then hold down Ctrl and
click with your mouse on B1 and K1) then make a chart as normal.

Hope this helps!

Cheers,
Ann