CODEWITHSUNDEEP
excel
Jyoti Prakash Mallick
Jyoti Prakash Mallick

Reputation: 2074

Multiple column value for Scatter graph in excel

New to excel.

Have an excel file with multiple columns with value associated for each column. I want to put them in a single scatter plot graph. How to achieve this. I was able to do it for single column and its value.

Single Column scatter plot:

enter image description here

Want to include all the column and their value.

Upvotes: 0

Views: 797

Answers (1)

user14435933
user14435933

Reputation:

Simplest way to achieve this is,

  1. Keep the first row as header name and value
  2. Copy all the values to a horizontal line using the transpose option in the excel against the name.
  3. Then click on insert and select the scatter plot graph.

enter image description here

Upvotes: 1

Related Questions