Timeline for Creating a stacked area chart which shows negative values
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 28, 2017 at 6:33 | answer | added | IQV | timeline score: 3 | |
| Mar 27, 2017 at 7:31 | comment | added | IQV | @PaulSmith Sorry, I didn't read your question exactly and I didn't check my try exactly. So after analyzing and playing around with some numbers I found out, that an stacked area chart doesn't work for you. When you switch to a stacked line chart you better see what happens. For your case I found out, that your column for Division C must be the first; then you get what you want, but only as line diagram. But this solution does only work for your case, not generally. Especially if another division makes losses, it doesn't work. | |
| Mar 24, 2017 at 21:44 | history | edited | fixer1234 |
edited tags
|
|
| Mar 24, 2017 at 13:43 | history | edited | DavidPostill♦ | CC BY-SA 3.0 |
deleted 119 characters in body
|
| Mar 24, 2017 at 11:46 | comment | added | Paul Smith | Unfortunately I do not have access to excel 2010 and must use 2013 | |
| Mar 24, 2017 at 11:45 | comment | added | Paul Smith | Hi thanks for getting back to me, I have attached an image for the problem above thanks | |
| Mar 24, 2017 at 11:45 | history | edited | Paul Smith | CC BY-SA 3.0 |
added 122 characters in body
|
| Mar 24, 2017 at 11:20 | review | Close votes | |||
| Mar 27, 2017 at 4:52 | |||||
| Mar 24, 2017 at 10:53 | comment | added | mic84 | Welcome to Super User: to post images. Go to editing click in the area you wish the image to be placed then click on the image icon above the editing box. This will open a dialog box that will yet you search for the image on your computer, click on it and it will up load the image to this site(like email) | |
| Mar 24, 2017 at 10:49 | history | edited | mic84 | CC BY-SA 3.0 |
format
|
| Mar 24, 2017 at 10:25 | comment | added | IQV | I tried this in Excel 2010 and it worked as you want: The negative values are below x-axis and the others stacked above. | |
| Mar 24, 2017 at 9:55 | review | First posts | |||
| Mar 24, 2017 at 10:53 | |||||
| Mar 24, 2017 at 9:55 | history | asked | Paul Smith | CC BY-SA 3.0 |