Share via

How to plot a graph with multiple variable in single graph by one variable

Anonymous
2023-04-26T05:31:08+00:00

Hi

I have 5 variables on basis i have some efficiency. Now i want to plot a effective single line graph with one variable.

For Example

i want a single graph with wrt var1 to check the optimal condition of better Effeciency

Var1 Var2 Var3 Var4 Var5 Eff
100 22 16 8.5% 28.5 80%
90 23 32 8.5% 28.5 90%
100 22 16 8.5% 25 95%
75 24 32 10% 25 87%
90 25 32 10% 28.5 86%
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-04-26T07:47:19+00:00

    Hi Baiju

    I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself.

    To create a scatter plot with VAR1 on the x-axis and EFF on the y-axis in Excel, you should follow these steps:

    1. Select the data range for VAR1 and EFF (excluding headers).
    2. Go to the "Insert" tab on the ribbon and click on "Scatter" chart.
    3. In the "Scatter" chart drop-down menu, select "Scatter with only markers".
    4. Add labels and titles to the chart as desired.

    These steps will create a scatter plot with VAR1 on the x-axis and EFF on the y-axis.

    I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

    Best Regards,

    AnnaThomas

    Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments