Design a digram for selected variables

[economistegypt2010]

Hi All,

The attached file includes some date. I need your support on how I can design a digram for selected variables for example to make a digram for just ( days and grand total)


I tried to select the 2 columns of variable for which I need to make a digram, however the digram includes all of the variables.

On a related issue, I need to know the best way on how I can make a chart or a digram for all of the denomination of the cards mentioned in the attached table.

Appreciate it if you can share with me the steps and do it for as an example.

[shg]

Is your attachment (which I don't understand), an example of your source data, or the desired result, or both, or something alse?

Do the colors represent additional unexplained information?

[economistegypt2010]

The attachment is an example of my source data. We can ignore the color.

[ahaj16]

Hi

I Have added a column chart for the data

X- Axis is Dates
Y- Axis is Grand Totals.

Excel Example.xlsx

check the above file

the above graph created for one variable data column ( Grand total )

you can add series to this graph for other columns. the graphs will be as in the following file :

Excel Example 2.xlsx

[economistegypt2010]

Hi. I would like to give you more clarification about what I wanted to do .

I need to make a chart or a digram for just 2 element (grand total and date) of the above sheet. Another exaple is to make a a chart or a digram for denomenation 25000 and grand total

[ahaj16]

check this file which contains 2 charts as you have requested.


Excel Example.xlsx