Tuesday, 27 July 2010 12:00 PMModerator
I am aware of that this question could better be asked in Excel or Reporting Services forums. But I would need to explain a lot more and so I hope, that someone has already had a similar request and can tell me how to solve (or that it is not possible at all).
I have a project custom field with look up table, I use a cube to create my report.
I need to create a chart report with following requirements:
- Actual Work as stacked column (color change by project enterprise field value)
- Baseline Work as stacked column (color change by project enterprise field value)
- Baseline Work and Actual Work next to each other, x axis is time
- A line above these columns reflecting capacity
In Excel (2007+) I had been successful to get both stacked columns next to each other, but I can’t add capacity line, since this value is also splitted into my project category.
In Reporting Services (2005+) I can get the capacity line as I want to have it, but I need to decide if I want to see actual+baseline work together in one stacked column or next to each other.
I see the reason for this request, so I hope someone was already asked a similar question. However I am not sure if it possible at all. Is there any experience on something like that?
Thanks in advance!
Thursday, 29 July 2010 8:06 PMOwner
I don't have a good answer for this - but one possibilty might be to pull the required data into different sheets in Excel, and then produce a consolidated graph by reference to the other sheets, rather than trying to do it all in one step? Someone smarter than me might have a better answer.
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
Friday, 30 July 2010 11:01 AMModerator
thanks, I will give it a try.
Friday, 30 July 2010 8:13 PMModerator
sorry for unmarking as answer. There are some people not reading answered questions and I hope that I will get some additional ideas during next week. I will mark as answer if nothing else happens in a few days.
Monday, 2 August 2010 5:08 PMOwner
Monday, 2 August 2010 6:14 PMModeratorThis might work, if I understand the request properly:- Andrew Lavinsky
Monday, 2 August 2010 6:16 PMModerator...although you might need to create a column to total Capacity across EnterpriseProject Type (assuming I understand the question).- Andrew Lavinsky
Wednesday, 4 August 2010 7:44 AMModerator
thank you for your idea. English is not my native language, so I think I could not explain what I want to achieve. Maybe I only don't understand what can be done with these horizontal lines? Here is a screenshot - I faked it with an image program. I am able to display actual work and baseline work as I want to. But I couldn't get the capacity line in there so far.
I have tried to do as Brian suggested, but I am also not successful with his idea.
Wednesday, 4 August 2010 12:52 PMModerator
How do you embed the picture? I haven't been able to figure out how to do that.
I still think that would work. Try this:
1) Right click on the chart, and Select Data
2) Add the Capacity data to the chart. It will probably show up as a bar on top of the other bars.
3) Left click on Capacity in the Legend. Select Change Series Chart Type
4) Set to Line Graph
- Marked As Answer by Barbara HenhaplMVP, Moderator Friday, 6 August 2010 10:57 AM
Wednesday, 4 August 2010 1:12 PMModerator
I have searched a lot this morning, to get that picture in there. ;-) I uploaded at http://www.tinypic.com/, that gave me some html string I put here in HTML editor.
What you described was one of my first tests. If I want to have actual and baseline work next to each other as stacked columns, I am only able to change to chart type for each project category, not for my measures. My legend are the project categories, not actual/baseline/capacity.
Moreover it is not possible to add additional measures to the chart. Using a pivot table as base for a chart seems to mean to take this one and nothing else.
If I move "Summary: Values" to legends (no idea if I translated that to the Microsoft term?), I loose my actuals and baseline values next to each other.
Thanks a lot!
Wednesday, 4 August 2010 3:47 PMModeratorHmmm....then not sure without the file in front of me. Good luck....
Wednesday, 4 August 2010 7:12 PMModerator
thanks a lot for support and trying. I think I will give it up, if I don't find a solution until next weekend. I have tried any checkbox and option I could find, seems that it is a limitation of Excel. But at least I do now know the ribbon of Excel quite good. ;-) It is true what I have read in a blog recently: Prepare for Project Server 2010: Go back to Excel school.
Friday, 6 August 2010 10:56 AMModerator
I gave up - seems it is not possible.
Thanks to both of you!