Excel: Dynamic update chart with data based on multiple rows

[the_julle]

Hi All.

I trying to make a chart in Excel grow dynamically based on a couple of user inputs.

I have data from 24 months, but I want to be able to choose how many of these month to show, and which month should be the first month in the chart.

I have followed this guide
Chart the Last 12 Months Dynamically

Based on this guide, I can only achieve my goal if my data is on the same column. ==> see file 'Testing with dynamic charts; One line'


However, I want to have my data on 2 columns instead. ==> see file 'Testing with dynamic charts; Two lines'



How can i change the formula in the Name Manager so it can be used with file 'Two lines'?


I have uploaded the two files on my ftp, just copy this location to your Windows Explore:


<code>ftp://Gaest:Gaest@80.162.41.250/sda1/Gaest/
</code></pre> Hope you can help. Thanks!
Alex.

 

[Andrew Poulsom]

Welcome to MrExcel.

Your link doesn't work for me. Can you put the workbook on a share like Box.com and post the URL?

 

[the_julle]

Welcome to MrExcel.

Your link doesn't work for me. Can you put the workbook on a share like Box.com and post the URL?

Thanks Andrew

The files are now uploaded on a HTTP site:
One Line
Two Lines

Does these links work for you?

 

[Andrew Poulsom]

Yes they work. can't you set out your data like this?

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	Start konto d. 10/12-2013	11000
2		2013												2014
3		Jan-13	Feb-13	Mar-13	Apr-13	May-13	Jun-13	Jul-13	Aug-13	Sep-13	Oct-13	Nov-13	Dec-13	Jan-14	Feb-14	Mar-14	Apr-14	May-14	Jun-14	Jul-14	Aug-14	Sep-14	Oct-14	Nov-14	Dec-14
4	Overfrt	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500	8,500
5	Hvet	18,650	7,150	6,650	10,650	6,650	6,650	8,150	6,650	6,650	10,650	6,650	6,850	18,650	7,150	6,650	10,650	6,650	6,650	8,150	6,650	6,650	10,650	6,650	6,850
6	Flyttet overskud	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7	Teoretisk: Konto	850	2,200	4,050	1,900	3,750	5,600	5,950	7,800	9,650	7,500	9,350	11,000	850	2,200	4,050	1,900	3,750	5,600	5,950	7,800	9,650	7,500	9,350	11,000
8	Faktisk: Konto pr. d. 10	900	2000	3500	2300	3400	5000	7000	6000	7000	9000	9000	11500	1000	2500	3500	2300	3800	6000	6500	7000	9000	7800	9500	12000
Overview

 

[the_julle]

Thanks for your replay.

That is how the 'One Line'-document already is. My question is, if I can arrange my data like shown in the 'Two Lines'-document, as that is how I really want it

 

[Andrew Poulsom]

I don't think that's possible, sorry. I would use a range like the one in your One Line document for the chart and another range for display purposes it that's what you want.

 

[the_julle]

I don't think that's possible, sorry. I would use a range like the one in your One Line document for the chart and another range for display purposes it that's what you want.

Can you give an example?

 

[Andrew Poulsom]

Just duplicate your data, one range for display and another range for the chart, somewhere out of view.

 

[the_julle]

Just duplicate your data, one range for display and another range for the chart, somewhere out of view.

Isn't there a better way of doing this? Do I have to have duplicated hidden data, only to achieve a simple goal of having my data on two rows instead of one?

 

[Andrew Poulsom]

If I knew of a better way I would have given it to you.