Create Line Chart With Different Marker & Condition

[galihsaputra]

Hi Master,


i try to make line chart with some condition. and i made a quick draft with paper and try input to excel.

draft.PNG

and i also try to create in excel, but i dont have any idea for some condition.

could you please give me support for this

Inventory Graph.xlsx

[MrShorty]

I'm unable to fully relate the data in your sample file to all of the elements in the hand drawn chart, so I cannot suggest a detailed solution. I will say up front that many charting questions often end up being more about the spreadsheet than the chart, and I think that will be the case here. Often, when you get all the data you need well arranged in the spreadsheet, the chart will be easy to create.

What I see in your hand-drawn chart is a line chart with a date axis or a scatter chart. In your file, I notice that your "dates" in row 3 are all text strings and not numbers. As such, you cannot get use a chart with a numeric/date axis. The numeric/date axis will be necessary in order to get the "vertical" lines you are showing in your hand-drawn chart. I'm not sure how you will want to change your month'year text to real dates or numbers, but you will need someway to make these numbers/dates and not text.

I also cannot see some of the values present in the data table (like the data for the GN Inventory "box" between June and September 2023). You will need to make sure all of the data needed for the chart is somewhere in the spreadsheet.

In order to get the "vertical" effects shown in the "GN Inventory box", the GM curve, and the IAMI curve, you will need multiple entries/columns for those months. Your hand-drawn chart shows 5 points in Jun "going up" and 5 points in Sep "coming down," so you will need at least 5 entries/columns for each of those months in the spreadsheet.

Keeping data in rows as you currently have it, I would then expect a chart table that looks like:

Please Login or Register  to view this content.

Once you have all of the data arranged in the spreadsheet, then you should be able to select this table insert your scatter/line chart, and format chart elements as needed.

Does that help at all?