Sorry, I put numbers in for each project and tried to explain how I would like the bars to look. This is how I have the data in the spreadsheet (is this the source data?)
A B C D
1 10 6 5
2 15 10 3
3 12 12 3
Here is some simple sample data that will hopefully demonstrate what I would like to bar chart
Group of first bars = Project 1
Bar 1 = Inital Planned Funds (10K)
Bar 2 = Expended Funds(6K) stacked with Current planned funds remaining (5K)
Group of second bars = Project 2
Bar 1 = Inital Planned...
Let me restate. Can I combine grouped and stacked bar chart? If I select a subtype of grouped, I can't stack variable and If I select subtype stacked, I can't group like variables?
Is it possible to create a custom cell pattern in Excel? For example, I would like to create a modified pattern of the horizontal stripe, where there is only one stripe in the middle of the cell.
Possible or Not??????
Sometimes I send out spreadsheets and 3 months later I see my spreadsheet being sent to someone else. The data is out of date or being misrepresennted. How can I limit access the file to force the user to come back to me for the most upto date file. By limit, I mean the file can only be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.