microsoft excel – Creating Bar Chart with Start time and End time

I want to create a bar chart from the following data which will look like the attached picture. The data will have a start time, end time, and a number value. Which will look something like this:

[Bar Graph][1]

Mainly, I want to create a timeline in the X-axis and I want to see from when to when the “number” is ranging. I tried to use the default bar graphs in excel but they are just showing each bar separately.

[normal bar chart][2]

I tried to search a lot about this but couldn’t get any direction. Any help would be greatly appreciated!
[1]: https://i.stack.imgur.com/TLivG.png
[2]: https://i.stack.imgur.com/HA3dw.png

technical analysis – Compare different coins in one chart

Is there a website where I can compare different coins in one chart? Like a chart where each coin, starts with the same value (say a value of 100$) at a certain date/time.

https://www.cryptocurrencychart.com/chart//marketCapCumulativeChange/USD/linear/-1%20year/now

is one such site which allows me to see this, but the minimum period it allows a comparison is for a week. I need a chart where the prices are changing by the second and I can compare different coins even for a 5 minute period, not just weekly or monthly comparison

numbers – How to color code individual data points in line chart

This is a question about using charts in Numbers and color coding individual data points in a series.

I have two series of data (blood pressure readings) that I plot in a chart. The series may contain multiple readings made at different times on a day, or there may be a single reading.

Is there a way to color code the data points in each series to indicate which part of the day the reading was taken? e.g. 6am-10am = purple, 10am-2pm = orange, 2pm-6pm = blue, etc.

The reason I want to do this is to distinguish between readings taken before and after taking medication.

Here's the chart

Google Data Studio – getting Returning Users in a bar chart

I am new to Data Studio, so forgive me if it’s a silly question. This is also my first question on StackExchange, so be nice to me :-]

I am trying to get returning users’ % on a bar chart. It’s more of a visual effect that I want to create.

Returning Users bar chart

My goal is that I should have 10% returning users on my website. So I have standardized the second bar to 10%. Now as we know data studio is unable to get returning users directly from google analytics, so I have created the segment and managed to get the number on a scorecard. But now I am not able to get it on a bar chart. I cant seem to get how to use that segment to calculate the % of returning users from the total users and then display it on the bar.

This is how my Total and New User bar looks like since I am able to get the metrics directly. For now, I am having to enter the returning user manually but I would like to automate it.

enter image description here

google sheets – How do I chart timeseries data organized by one of the columns?

Here’s what seems to be a simple common thing in excel/sheets that I can’t seem to be able to google in the right way (for hours). three columns: timestamp, email, things_done.

I want a chart with time as the X axis, things_done as the Y axis, and a line for each email.

The things_done could be grouped by week or even month and that would be pretty good.

Ideally I would be able to point some tool at this data and be able to do various things with it like choose weather to group by week or month, look at 5-week moving average, etc.

I’ve been able to sort of achieve this with multiple sheets to get to a pivot table, but the resultant “smooth” chart doesn’t want to consistently connect the dots. And in general my setup is very inflexible.

Is there a way (or third-party tool) to go straight from my source data described above to a nice looking chart with the time aggregation of my choosing (and bonus points for ability to add moving average)?

microsoft excel – Stacked Area Line Chart with Overlapping Values

I’m trying to create an attendance chart. Previously, there was only 1 time slot, so I used a line chart. However, now there are 2 time slots. So, I’d like to do a stacked area line chart to summarize both individual and total attendance between both time slots. The problem is that some attend both time slots. I don’t want the total attendance for the day to be skewed (i.e. total number of people in attendance), nor do I want the attendance for each time slot to be skewed.

How can I track the attendance accurately and represent it on the chart? Is there some way I can specify an “overlap” in attendance (i.e. 100 at time 1, 100 at time 2, 25 at both, for a total of 175 for the day)?

d3.js – How to hide overlapping labels in D3 chart (Observable)

I am working on a 100% stacked area chart in Observable with labels for each series, but I have a ton of series and would like to hide the labels for series that are too small to display (currently they are all scrunched on top of each other). Is anyone able to advise on how I can do this?

I created an if else statement and know I need to somehow say that if the value is below a certain share of the total, don’t display the label, but I am struggling to figure out what exactly needs to go in that statement. If anyone is able to advise, that would be extremely helpful!

Current notebook: https://observablehq.com/d/b981c470fa4ebddc

8 – D8 Charts – How do I create an aggregated combo dynamic chart in Views (see photo)

I’m trying to build a chart like this with the CHARTS module…

Chart Example

With 1 content type called “Cars”. The Car node can be categorized with fields for both the “Brand name” and “Model type” (both are taxonomy terms reference fields).

I want to display a column chart showing the number of nodes (inventory, y-axis) for each “Model Type” grouped under the “Brand Name” on the x-axis.

I’m aggregating in views, but can’t for the life of me, figure out how to execute and output such a chart. Please help!

Thanks!

Edit: The key here is “dynamic”… the number of “model types” could go up to 50+… so individual child charts for each model would not work.

google sheets – Generate a line chart with each player’s running score (competition tracker)

I asked this question on https://www.reddit.com/r/excel/comments/mikwvz/competition_tracker_create_publicly_accessible/?utm_source=share&utm_medium=web2x&context=3, but didn’t get an actionable (at my level of expertise) answer.

Using Google Sheets I’m trying to create a competition score tracker/graph that displays this information:

Each time an answer is submitted, the response sheet will display the time of the submission, the player’s name, and 8 “flag” cells, one for each flag in the challenge. The only flags that will have data will be correct flag submissions (thanks to Google Form’s “response validation”), and my expectation is that each player will be submitting once for each flag, although players can and should be allowed to submit multiple flags at once. Once factor that I have to account for is that players might re-submit previously submitted flags, so I want to account for that before the score is tallied and displayed on the graph.

Along the X-axis, the graph would track the time that each answer is submitted.

Along the Y-axis, the graph will display the total score.

Each colored line in the line graph will be a different player (my expectation is approx. 5-10 players total). As I linked in the reddit post, my hope is to display a graph that functionally resembles this one

and I’ll use Google Sheets to “publish” the graph so that it can be viewed throughout the competition.

Anyone knows free application or program to learn about bitcoin chart and bitcoin update for free?

Stack Exchange Network


Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange