how to make this kind of graph in excel

i am new to excel please help me to make such graphs in excel

Link to chart hosted on third-party site removed --6StringJazzer

Attach a Workbook ** with the data **
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Do not post links to gossip and risque picture sites

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

ijazali, please do not link to third-party sites when it is so much easier to simply upload your file here. To give you the benefit of the doubt I am leaving this thread open but the site you linked to runs click-bait links to drum up their numbers. Here is your image.Capture.jpg

Now, show us your data and we'll show you how to make the chart. It's a matter of using logarithmic scales for both axes.

Originally Posted by 6StringJazzer

ijazali, please do not link to third-party sites when it is so much easier to simply upload your file here. To give you the benefit of the doubt I am leaving this thread open but the site you linked to runs click-bait links to drum up their numbers. Here is your image.Attachment 362979

Now, show us your data and we'll show you how to make the chart. It's a matter of using logarithmic scales for both axes.

i am sorry for posting on 3rd party sites, my mistake,,

basically i want to plot planks law in excel for different temperatures and wave lengths, but could,t succeed...

here are the temperatures values
T= 300K , 400K, 1000K, 3292K and 5800K

the wavelength (lambda) ranges from 0.1 to 100 micro meter

please show me step by step procedure, it will be nice of you, thank you

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

How much instruction do you need?

Step by step for creating scatter plots: https://support.office.com/en-us/art...rs=en-US&ad=US

This help file shows how to change a linear axis to a logarithmic axis: https://support.office.com/en-us/art...rs=en-US&ad=US

This help file explains how to add/remove data series (since I expect you will create the chart with one data series, then add the other data series to the charts: https://support.office.com/en-us/art...-US&ad=US#bmxl

If you need help creating the spreadsheet on which the chart will be based, let us know. At this point, we are assuming that you are familiar with using spreadsheet formulas to create the data in the spreadsheet.

See attached.

I realize it has been a couple of days. If you are still interested, exactly what is your question? Based on your spreadsheet, adding a fifth isotherm should be as simple as adding another column to the spreadsheet and adding that column as a fifth series in the chart. Having created a table and chart with 4 isotherms, adding a fifth isotherm should be trivial.

If you also want to add the curve that connects the "maxima" of each isotherm, that should be easy enough if you have the spreadsheet calculate the X and Y values for those maxima (based on the equation being used), then add that series of X,Y values as a 6th data series.

Originally Posted by ijazali

...no body helping me here

IMHO - it is wrong description of the situation.

There were several attempts to help you, usefull links, attempts to understant the issue, suggestions like "have the spreadsheet calculate the X and Y values for those maxima... then add that series of X,Y values as a 6th data series.". etc,

Simply - nobody did your work.

But if you think help is less advice, more substitution: Yes, nobody helped.