sharadmaxwell
New member
- Joined
- Jun 27, 2018
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2007
Hello Experts
I attached herewith excel file, In which i prepare PIE chart in Sheet2 using data in Sheet1
in row thare is Date and in Values there is amount
i want pie chart as per my below condition
1 - Monthly
2 - in month two division from 1st date to 24th and from 25th to last date of the month
suppose if i select NOV
then pie chart should show
one color of 1st date to 24th
and another color of 25th to last date of the month
I dont want to add any other coloum in main Data
I HOPE you understand, please suggets the solution
thanks in advance
I attached herewith excel file, In which i prepare PIE chart in Sheet2 using data in Sheet1
in row thare is Date and in Values there is amount
i want pie chart as per my below condition
1 - Monthly
2 - in month two division from 1st date to 24th and from 25th to last date of the month
suppose if i select NOV
then pie chart should show
one color of 1st date to 24th
and another color of 25th to last date of the month
I dont want to add any other coloum in main Data
I HOPE you understand, please suggets the solution
thanks in advance