how do I a) get both data labels (domestic and import to show up with their respective categories, b) include a legend.
am simply organizing the date wrong?
how do I a) get both data labels (domestic and import to show up with their respective categories, b) include a legend.
am simply organizing the date wrong?
PLease take a look at tab SHEET5 (2)
see how I structured the data and chart in the attached
Happy with my advice? Click on the * reputation button below
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please understand Miss Moderator, that this my first time ever posting a thread so I have no idea what "substantive details" are. I apologize if my questions are unclear but again I rarely ask the right questions, because I do not know exactlywhat I want, just a rough guesstimate. Thank you for your understanding-llyod276.
In the end this is what I came up with as best as i could get when messing around with the data. Pls see sheet three. Thank you both for the results you have submitted, "rcm" and "Crooza". I wish there was a way to take the results and put the columns side by side in descending order, but I do not think excel allows for this.
Last edited by llyod276; 12-10-2018 at 04:55 AM.
You will need to prepare the data in order to create 2 series and for it to be sorted.
The assumption is sorting is within Domestic and Import.
The series overlap is zero and the column gap has been reduced.
gorgeous, I love it. and here's the end result i really wanted using your formula +1. (the +1 refers to an added stat, like dungeons and dragons stat, sorry i'm a nerd.)
I actually figured this out using a different graph for a different set of values (scatter plot). so far I've invested 16 hours into this project and its due wednesday
.
and i think i have the wrong data
For those of you who care and want to see what you have contributed to this project this is for you. thank you all. By the way Miss Moderator, I seem to be unable to close this thread could you do it for me, please, and put it down as solved?--llyod276
P.S. Miss Moderator- AliGW your name is very reminiscent of a movie( a good movie at that) by the name of Ali G.
Last edited by llyod276; 12-12-2018 at 06:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks