Thread: Charts: Legend problem with variable length

Hi there,

i've a problem while generating a Chart..

Let me explain the Table and the goal.

Col. A shows 1-25 so 25 Rows given. An Group may have 1 up to 25 Accounts. Lets guess Group 1 has 5 Accounts. Creating a Chart now Legend shows 5 Account Names but also 20 Entries without Names.

Next Group may have 10 Accounts. So Chart shows 10 Accs and 15 without names.

How can I create this Chart showing only Accounts which have also a "real name".

Thanks in advance

Cheers
LouSifer

Problem is that the Report will generate 500 Group Reports via Macro. So the Report should stay as flexible as it is

ok let me try to get more detailed

It is a Master Report which creates a Report for each Group.

So Macro will run for first Group (which contains 5 Accounts). Update Data (also the Charts) and paste as WB and Values in new File.

Afterwards Master Reports switch to 2nd Group. (which contains 10 Accounts) and so on.

Unfortunately Master Report is over 35 mb large

mhh yea could do via Macro. But thats my last way.

I think im on another good way. If you're interested in result just let me know.

Thanks for your help so far

Got it..

With using Names and Offset (Count) Formula in name references it works.

Define Col A as Cht_X_Value and use Offset and Count on that Col.
Define Col B as Cht_Y_Values and do same on that Col.

Afterwards in Chart Source refere for Values to named Section Cht_Y_Values.

Works fine and without Macro

If you like I can send you an Excel file showing the details.

Cheers

Hi again,

attached the WB.

Select different Group to see how it works.

Also the Name (Offset Formula) Cht_Y_Value and the refere to Value in Chart is important.

Hope that helps other also.

BR
LouSifer