• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Sparkline Question.

M. Qayyum Anwar

M. Qayyum Anwar

New Member
Hi Everybody,

I am trying to make a speadsheet using sparkline (See attachment). My question is:

1. How to add baseline to sparkline to monitor two levels of my available stock on monthly basis.
2. if this is not possible by sparkline, what could be the alternative solution.

Thanks to all in advance.

Qayyum
 

Attachments

  • StockLevel.jpg
    StockLevel.jpg
    178.3 KB · Views: 17
Thanks bob this link is really useful. what if i want the horizontal axis to show two limits like in my sheet Stock Limit Level 1 which 1000 and Stock Limit Level 2 which is 500. Actually what I want to do is as follows:

1. I am monitoring my stock with two limits. If I reach to Stock Limit 1000 I take necessary measures to re order these items.
2. When I reach to Stock Limit 500 it is an alarming situation.

I want the trend showing these two limits.

Regards,
 
@M. Qayyum Anwar There is no option to show lines / bands on sparklines. The axis option may not work for you as you need 2 lines.

One approach is to create 3 sets of sparklines and overlap them one on top of another to get the effect, using picture links.

Something like this:

screenshot-097.png

See attached workbook with that solution. As you may notice, this is not pretty.

I suggest creating a regular line chart and shrinking it. This will give you more flexibility and formatting choices.
 

Attachments

  • sparklines-with-bands.xlsx
    23.5 KB · Views: 6
Thank you for your response. you are right, using multiple sparlines and overlapping them is not so pretty. would you please elaborate on howto create a regular line chart and shrinking it. please note that i have almost 200 items and i need line chart for each item.
 
Dear All,
I have checked both attachments from Narayank991 and vletm. Let me redefine and think to other solutions:

1. The ReOrder Stock Level 1 and Level 2 will be different for each product. If I go with sparkline solution, it will be difficult to assign bands due to limitations.
2. What if I use simple sparkline to show the trend or movement of my stock and use conditional formating to show all numbers in ORANGE if it is <=Level 1 and RED if it is <=Level 2. this way i can assign to each row the reOrder levels.

please advise with thanks to everybody.
 
@M. Qayyum Anwar
You can easy to set any kind of levels to all 'charts'; in my sample.
Sparklines are quicker to make, but without those levels.
There is a challenge in both ways; y-axes.
Even small changes could give 'wrong' image, if not take care of y-axes scales.
If You need those Level-lines, then You should use charts.
There is conditional formating layout in my sample too.
Ideas?
 
I'll do it ASAP, it need still some modifications.
Do You have any hopes of colours, font sizes and so on?
And ... I have to set default values for Level1 & Level2.
 
@vletm, sorry for not replying you earlier as i am in a travel and unable to concentrate on this sheet. Please allow me some more time until i come back and test this sheet. it might take just couple of days.

Once again thanks a lot and sorry for inconvenience.
 
You must log in or register to reply here.
Back
Top