Prev Previous Post   Next Post Next
  #1   Report Post  
Monty
 
Posts: n/a
Default help

Can anyone out there help me with setting up a graph for the following info.
See bottom of page for example of what i am looking
Cost Centre Received in Finance No Days
2010 May-04 29
2010 May-04 15
2010 May-04 21
2001 May-04 14
2026 June-04 34
2038 June-04 30
2010 May-04 17
2028 June-04 39
2010 May-04 26
2032 June-04 15
2027 June-04 13
2017 June-04 18
2017 June-04 17
2017 June-04 21
2001 June-04 21
2038 June-04 19
2037 June-04 30
2034 June-04 15
2017 June-04 24
2038 July-04 15
2017 July-04 20
2021 July-04 27
2027 June-04 107
2021 July-04 17
2028 July-04 28
2032 July-04 76
2027 July-04 76
2032 July-04 71
2022 August-04 24
2026 August-04 33
2028 August-04 36
2028 August-04 55
2002 August-04 16
2022 August-04 33
2022 August-04 33
2022 August-04 33

I would like the report to run monthly with the cost centre on the y axis
and the amount of days on the X axis. I have set out the month of June as an
example.

Ie CC 2027 month of June-04 = 120 Days Two occasions
2026 €œ €œ = 34 €œ One €œ
2038 €œ €œ = 49 €œ Two €œ
2028 €œ €œ = 39 €œ One €œ
2032 €œ €œ = 15 €œ One €œ
2017 €œ €œ = 70 €œ Four €œ
2001 €œ €œ = 21 €œ One €œ
2037 €œ €œ = 30 €œ One €œ
2034 €œ €œ = 15 €œ One €œ


thanks
M

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"