Graph in straight table

[rassanbekov]

Hello!

Please help to construt the graph within the table

I have data on Accounts receivable balance over the period. I need to show graphically openning balance, closing balance and to-date balance. For example,

Header 1	Header 2	Header 3	Header 4
A	40	20	15
B	15	22	88
C	50	10	100

Let's say, in "Header 5", there should be graphical movement of abovestated balances.

Kind regards,

[Anil_Babu_Samineni]

It would better if you provide sample output in tabular format for [Header 5]

[rassanbekov]

somethinh like this should appear

[Anonymous]

may be you can use minicharts.

[rassanbekov]

It's clear that I can use minibars but I have no idea how to tailor to this particular case described. Because I need to show the points on graphs of several fields...

[Anonymous]

Can you share exact requirement so that we can try to help you

[rassanbekov]

The requirement as follows

I have several fields with figures as stated above "headers 2,3,4". I need to construct minibar in header "header 5" as I have attached pic. Please describe the formula to fulfill this.

[Anonymous]

Like this??

[rassanbekov]

Yes, but I cannot understand how to make "value" field. I have input data as follows:

I need somehow make crosstable?

Could you please help how to make "value" field from

[BB, Сальдо на начало],

[EB, Сальдо на конец],

[Сальдо на конец].

since I have different sources...

LOAD	Index,
	[Company name],
			[BB, Сальдо на начало],
		[EB, Сальдо на конец],

FROM [0_ISS\Processed\ProcPopulation 31.12.2016.xlsx] (ooxml, embedded labels, table is Sheet1);

Directory;

Load * , If(Оплачено=0,0,1) as Flag;

LOAD	Index,
		Company as [Company name],
		Region as Region,
		[Сальдо на начало],
		Начислено,
		Оплачено,
		[Сальдо на конец],

FROM [0_ISS\Processed\ProcPopulation 01.01.2017-20.05.2017.xlsx]

(ooxml, embedded labels, table is Sheet1);