Monthly line graph with two lines in Excel 2016How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?MS Chart Control Scale - Line graph show 12 monthsSummarizing Excel Data with a graphLine graph in R comparing values in 2 columnsCreating a Year Over Year Line Graph Based on Pivot TableExcel - Multiple subsets of data on one line graphLine graph in ggplot R with one numeric variableExcel Graph - 2 Line chart / Each line representing it's own data setMultiple series into one line in line graph in Excel?

What is this welding tool I found in my attic?

What would the EU do if an EU member declared war on another EU member?

Why can't supermassive black holes merge? (or can they?)

Referring to different instances of the same character in time travel

Why did my rum cake turn black?

Repeating redundant information after dialogues, to avoid or not?

Credit union holding car note, refuses to provide details of how payments have been applied

Correct use of ergeben?

Can I intentionally omit previous work experience or pretend it doesn't exist when applying for jobs?

Why are Hobbits so fond of mushrooms?

A DVR algebra with weird automorphisms

Are randomly-generated passwords starting with "a" less secure?

How do I determine whether a permit is required for a new gas line?

Is killing off one of my queer characters homophobic?

Returning the argument of a function if the argument is not of the right type

Are neural networks prone to catastrophic forgetting?

Steampunk helicopter

Can I play a first turn Simic Growth Chamber to have 3 mana available in the second turn?

diff shows a file that does not exist

How did the hit man miss?

Is a Lisp program in both prog-mode and lisp-mode?

Keep milk (or milk alternative) for a day without a fridge

The monorail explodes before I can get on it

Stuck Apple Mail - how to reset?



Monthly line graph with two lines in Excel 2016


How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?MS Chart Control Scale - Line graph show 12 monthsSummarizing Excel Data with a graphLine graph in R comparing values in 2 columnsCreating a Year Over Year Line Graph Based on Pivot TableExcel - Multiple subsets of data on one line graphLine graph in ggplot R with one numeric variableExcel Graph - 2 Line chart / Each line representing it's own data setMultiple series into one line in line graph in Excel?






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I am trying to plot a montly line graph for below data from Jan to Dec with Overall Share % on Y axis and Months, Mumbai & Delhi on X Axis. I need two separate line for Mumbai & Delhi for "Overall Share %". I tried to add a line graph for the data, but it is creating one single line for both Mumbai & Delhi.



Can somebody help me to create monthwise line graphs showing two separate lines for Mumbai & Delhi for the below data?



enter image description here










share|improve this question






















  • have you tried using a second series ? looks like you're plotting everything in the same series, therefore a single line. select data, add series, select only mumbai data for series 1, resp dehli data for series 2

    – Jo.lass
    Mar 26 at 7:27

















0















I am trying to plot a montly line graph for below data from Jan to Dec with Overall Share % on Y axis and Months, Mumbai & Delhi on X Axis. I need two separate line for Mumbai & Delhi for "Overall Share %". I tried to add a line graph for the data, but it is creating one single line for both Mumbai & Delhi.



Can somebody help me to create monthwise line graphs showing two separate lines for Mumbai & Delhi for the below data?



enter image description here










share|improve this question






















  • have you tried using a second series ? looks like you're plotting everything in the same series, therefore a single line. select data, add series, select only mumbai data for series 1, resp dehli data for series 2

    – Jo.lass
    Mar 26 at 7:27













0












0








0








I am trying to plot a montly line graph for below data from Jan to Dec with Overall Share % on Y axis and Months, Mumbai & Delhi on X Axis. I need two separate line for Mumbai & Delhi for "Overall Share %". I tried to add a line graph for the data, but it is creating one single line for both Mumbai & Delhi.



Can somebody help me to create monthwise line graphs showing two separate lines for Mumbai & Delhi for the below data?



enter image description here










share|improve this question














I am trying to plot a montly line graph for below data from Jan to Dec with Overall Share % on Y axis and Months, Mumbai & Delhi on X Axis. I need two separate line for Mumbai & Delhi for "Overall Share %". I tried to add a line graph for the data, but it is creating one single line for both Mumbai & Delhi.



Can somebody help me to create monthwise line graphs showing two separate lines for Mumbai & Delhi for the below data?



enter image description here







excel linegraph






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 26 at 4:43









MalteshMaltesh

881 gold badge4 silver badges11 bronze badges




881 gold badge4 silver badges11 bronze badges












  • have you tried using a second series ? looks like you're plotting everything in the same series, therefore a single line. select data, add series, select only mumbai data for series 1, resp dehli data for series 2

    – Jo.lass
    Mar 26 at 7:27

















  • have you tried using a second series ? looks like you're plotting everything in the same series, therefore a single line. select data, add series, select only mumbai data for series 1, resp dehli data for series 2

    – Jo.lass
    Mar 26 at 7:27
















have you tried using a second series ? looks like you're plotting everything in the same series, therefore a single line. select data, add series, select only mumbai data for series 1, resp dehli data for series 2

– Jo.lass
Mar 26 at 7:27





have you tried using a second series ? looks like you're plotting everything in the same series, therefore a single line. select data, add series, select only mumbai data for series 1, resp dehli data for series 2

– Jo.lass
Mar 26 at 7:27












0






active

oldest

votes










Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55349994%2fmonthly-line-graph-with-two-lines-in-excel-2016%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes




Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.







Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.



















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55349994%2fmonthly-line-graph-with-two-lines-in-excel-2016%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript