Last post Jan 29, 2020 10:03 AM by Lewis-H
Dec 14, 2019 12:20 PM|geetasks|LINK
How can one display Stacked bar with a point on it displaying current value? Eg. I am trying to display 'Horizontal Bar' with a point on it.
I want to plot logged in user's BP value. How can that be pointed in graph?
Dec 16, 2019 08:05 AM|yij sun|LINK
Accroding to your description,I couln't understand where the point vaule comes from. I suggest you could try to provide some example data.
If you could post more codes and description to us.It will help us understand your requirment and solve the issues.
Jan 28, 2020 12:06 PM|geetasks|LINK
Actually I had displayed stacked bar to display BP (ie High, low, normal value) something like below. Now after displaying the same, I want to display logged in User BP using a point on the graph created.
Couldn't make out how to display dot in stacked bar?
Jan 29, 2020 10:03 AM|Lewis-H|LINK
With your horizontal bar chart already in place make sure it is a stacked horizontal chart, then create the data for the blue dots like in the table of my screenshot. Select B12 to C19 and copy. Then select the chart and use Paste Special. Paste with these
options selected and all others unticked
That will stack bars onto the existing chart. Select the stacked series and change the series chart type to a Scatter chart.
The row position and the salary column are in the wrong order for our purpose. Using copy and paste, paste the row position into column D, then copy C11 to D19 and paste to B11.
Then add data labels with the option "Values from cells" and select A12 to A19.
Adjust the salary values and the formatting of the dots.