Hello there, I'm trying to install this sparkline but don't know how to do it. I did it with a chart as you can see it, but can I do with a sparkline? I have one sparkline working, but the side "85%" I can't seem to figure out how to have it as a sparkline. Does anyone know how to do it?
Thanks.
Sorry - I am not clear what you are trying to do. Can you give more specific detail?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I'm trying to replace that 85% chart with sparkline. I don't want to have a chart under the graph thing I want to have sparkline graph. Do you know understand?Originally Posted by AliGW
Last edited by sovietchild; 02-16-2018 at 11:08 AM.
OK, I get that, but what do you expect it to look like? And what have you tried so far?
Just like that but with the sparkline. I believe Iv seen this done before.
OK - first, remove the chart from that cell (all of it, including its background). Next, select the cell and go to Insert - sparklines will now be available. Choose the column type. See file attached.
Thank you for help, but the sparkline is not side ways, its more of upwards. And it does not really show that its 85% its shows as if its 100%.
Last edited by sovietchild; 02-16-2018 at 07:23 PM.
Oh I found how to do it. Its not the sparkline, its the conditional formatting.
OK, so are you going to enlighten us as to exactly what it is about the conditional formatting? Your sparkline looks fine to me.
On reflection, as this would now appear to have morphed into something else, perhaps you had better start a new thread with an appropriate title.
Last edited by AliGW; 02-17-2018 at 04:05 AM.
Here is the picture of a design that Im working on.OK, so are you going to enlighten us as to exactly what it is about the conditional formatting? Your sparkline looks fine to me.
Untitled.png
The conditional formatting worked fine for the Rate
Start a new thread, please. This is less about sparklines and more about CF, so you need a new thread with a new title. And, when you do so, don't just show an image and expect us to be able to interpret it without direction - I am afraid I have no idea what I am meant to be looking at there or what the perceived problem is!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks