Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
0 votes
1 answer
2k views

Google Sheets: Fill out dates and replace blank cells with zeroes

I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable: I think there are two reasons for this: Not all dates have values associated with them, and ...
frandude's user avatar
0 votes
1 answer
1k views

Stacking time series in Google Sheet Combo chart

I can approximate a stacked time-series plot using the Combo chart option in Google Sheets: But it's not quite a "real" time series plot because the temporal gaps are not represented. Compare to this ...
patricktokeeffe's user avatar
0 votes
1 answer
235 views

1 plot with several lines with a common X axis but unique X and Y values... is this possible?

I am trying to create a graph which shows several smooth lines that are defined by an X and Y value. the problem is that they have to share the X-axis. Is there a way to efficiently add the other ...
Peter Pan's user avatar
0 votes
1 answer
229 views

Google sheet chart, wrong time format in chart

I have created a Google Sheet that collects a bunch of values in columns. One of these is a time value formatted hh:mm:ss AM/PM, obtained with the following formula: =TIMEVALUE(SUBSTITUTE("April 28, ...
Riccardo's user avatar
  • 579
0 votes
1 answer
56 views

Comparison Column Chart

I'm trying to make a chart in Google Sheets to compare how much two people have paid towards something. What I'm looking for is the chart to have several cost categories (groceries, dining out, pets, ...
Shane Price's user avatar
0 votes
1 answer
36 views

Blank Redundant Month

I have a large list of days and quantities that I wanted to chart so we could see how many of something we sold on a specific day. Give this goes back 600 days, there is a lot of data so I have been ...
sageco's user avatar
  • 63
0 votes
1 answer
273 views

Dynamically creating chart in Google Sheets

I'm looking for a way of automatically generating a graph based on a constantly expanding dataset. The number of columns is constantly expanding (a program create a new column with new datasets for ...
Dalton Smith's user avatar
0 votes
1 answer
1k views

How to group certain data in a chart in Google Sheets

I'm creating a chart of a number of items (website traffic sources) and want to find a way to merge any rows that contain 'Facebook' in the chart. Here's the raw data: (direct) 67 192.com ...
Tom Perkins's user avatar
0 votes
3 answers
3k views

Multiple columns as one in an Google Sheets chart

I have a Google Sheet tracking data over days, logging data at different times during the day, example: Is there any way that I can have this data represented in a chart as one continuous line ...
physicsboy's user avatar
0 votes
2 answers
577 views

How to automatically plot multiple series from values in a column

In Google Sheets, I know I can plot multiple series into a chart by manually adding a series and selecting/specifying the source data for each series. But is it possible to use a third column to ...
Jonathan Cakes's user avatar
0 votes
1 answer
143 views

Sum of time in Google Sheets' chart

I tried to show a chart where the values are the sum of times. It looks ok in the spreadsheet with for example 19 hours and 25 hours but in the chart, the 19 is ok but the 25 is shown as 1. The format ...
Johan Hallgren's user avatar
-1 votes
1 answer
1k views

How can I change the min and max value of vertical axis in chart?

I want the vertical axis to range between 75 and 125. The min should be 75 and the max should be 125. 0 to 125 range is automatically generated. The highest data point is 107 and the lowest data point ...
Vaibhav Sharan's user avatar
-1 votes
1 answer
827 views

Google Sheets Pie Graph Aggregation Merges Completely Different Categories

I've been trying to make a basic chart in google sheets that puts together the time taken for various activities to make a pie chart. Since the same activities appear multiple times I need to ...
Ashvin Kannan's user avatar
-1 votes
1 answer
27 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
Carol.Kar's user avatar
  • 199
-1 votes
1 answer
868 views

Google Sheets trendline broken; file unavailable

In Google Sheets, I've created a line graph. I want to add a trend line. I do so by clicking the blue line and selecting Linear from the trendline dropdown. No trendline appears. Then when I right ...
MrJD's user avatar
  • 99
-2 votes
1 answer
309 views

Investing.com data uploaded but i am not able to use the data for email alerts.kindly help me [closed]

I have configured to fetch the data on every 1 min from investing wesite. The table data is fetching from website. while trying to update date when 15 minutes status D column change to either strong ...
Murali Pujari's user avatar
-2 votes
2 answers
1k views

Not getting sub date granularity in Google Sheets trend lines

My data is in variable increments, anywhere from six to eight hours apart like so: 1-1-2011 00:00:00 100 1-2-2011 00:00:00 103 1-3-2011 00:00:00 107 1-4-2011 00:00:00 109 1-4-...
cabbey's user avatar
  • 155

1 2 3 4
5