How to have two x columns and one y column in charts?
18 views
Skip to first unread message
Brittany Sattler
Feb 18, 2016, 9:07:20 PM2/18/16
to Google Visualization API
I am new to google sheets and can't figure out this one.
I have two x value columns and one y column that corresponds to both x columns. I am able to format the graph with one x column and multiple y's, but does anyone know how to do the opposite??
Thanks!
Sergey Grabkovsky
Feb 19, 2016, 10:07:24 AM2/19/16
to Google Visualization API
Hi Brittany,
It sounds like what you want is to change the orientation of the chart. Could you please elaborate on your use case? Give an example of your data, perhaps?
--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/97368e71-3e88-472b-a350-127d41d223be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
• | Sergey Grabkovsky | |
• | Software Engineer | |
• | Google, Inc | |
• |
Brittany Sattler
Feb 19, 2016, 1:17:05 PM2/19/16
to Google Visualization API
Stress vs. Elevation graph with two types of stress for the x axis
On Friday, February 19, 2016 at 7:07:24 AM UTC-8, Sergey wrote:
Hi Brittany,It sounds like what you want is to change the orientation of the chart. Could you please elaborate on your use case? Give an example of your data, perhaps?
On Thu, Feb 18, 2016 at 9:07 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
I am new to google sheets and can't figure out this one.--I have two x value columns and one y column that corresponds to both x columns. I am able to format the graph with one x column and multiple y's, but does anyone know how to do the opposite??Thanks!
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/97368e71-3e88-472b-a350-127d41d223be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Sergey Grabkovsky
Feb 19, 2016, 1:29:12 PM2/19/16
to Google Visualization API
It sounds like it might be better to have a Bar/Column Chart your Elevation be the x axis, and each type of stress would be a series. Something like this perhaps?
Is there a reason that this doesn't work for you?
On Fri, Feb 19, 2016 at 1:17 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
Stress vs. Elevation graph with two types of stress for the x axis
On Friday, February 19, 2016 at 7:07:24 AM UTC-8, Sergey wrote:Hi Brittany,It sounds like what you want is to change the orientation of the chart. Could you please elaborate on your use case? Give an example of your data, perhaps?On Thu, Feb 18, 2016 at 9:07 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
I am new to google sheets and can't figure out this one.--I have two x value columns and one y column that corresponds to both x columns. I am able to format the graph with one x column and multiple y's, but does anyone know how to do the opposite??Thanks!
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/97368e71-3e88-472b-a350-127d41d223be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
•
Sergey Grabkovsky
•
Software Engineer
•
Google, Inc
•
--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/9b082909-ce17-4a4b-ae5e-ed6cab11d096%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Brittany Sattler
Feb 19, 2016, 1:33:47 PM2/19/16
to Google Visualization API
I need to have it be a scatter plot to show the lines. its extremely easy to do this in excel, but google sheets is giving me problems with this
On Friday, February 19, 2016 at 10:29:12 AM UTC-8, Sergey wrote:
It sounds like it might be better to have a Bar/Column Chart your Elevation be the x axis, and each type of stress would be a series. Something like this perhaps?Is there a reason that this doesn't work for you?
On Fri, Feb 19, 2016 at 1:17 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
Stress vs. Elevation graph with two types of stress for the x axis
On Friday, February 19, 2016 at 7:07:24 AM UTC-8, Sergey wrote:Hi Brittany,It sounds like what you want is to change the orientation of the chart. Could you please elaborate on your use case? Give an example of your data, perhaps?On Thu, Feb 18, 2016 at 9:07 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
I am new to google sheets and can't figure out this one.--I have two x value columns and one y column that corresponds to both x columns. I am able to format the graph with one x column and multiple y's, but does anyone know how to do the opposite??Thanks!
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/97368e71-3e88-472b-a350-127d41d223be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
----
•
Sergey Grabkovsky
•
Software Engineer
•
Google, Inc
•
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsub...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/9b082909-ce17-4a4b-ae5e-ed6cab11d096%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Sergey Grabkovsky
Feb 19, 2016, 2:15:24 PM2/19/16
to Google Visualization API
Brittany,
I'm not sure I fully understand what you're trying to do. Scatterplots, by definition, do not have lines between them (although our scatter chart can do this). Also, if you're rendering a scatterplot, I don't understand why it matters that something is an x axis or a y axis, but you can use the 'orientation' option to make the domain axis vertical. However, our Classic charts (corecharts) do not support having two horizontal axes, but our Material charts do. Sadly, these Material charts are not yet available from Google Sheets, but here is an example of such a chart: http://jsfiddle.net/moko7c6b/
On Fri, Feb 19, 2016 at 1:33 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
I need to have it be a scatter plot to show the lines. its extremely easy to do this in excel, but google sheets is giving me problems with this
On Friday, February 19, 2016 at 10:29:12 AM UTC-8, Sergey wrote:It sounds like it might be better to have a Bar/Column Chart your Elevation be the x axis, and each type of stress would be a series. Something like this perhaps?Is there a reason that this doesn't work for you?On Fri, Feb 19, 2016 at 1:17 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
Stress vs. Elevation graph with two types of stress for the x axis
On Friday, February 19, 2016 at 7:07:24 AM UTC-8, Sergey wrote:Hi Brittany,It sounds like what you want is to change the orientation of the chart. Could you please elaborate on your use case? Give an example of your data, perhaps?On Thu, Feb 18, 2016 at 9:07 PM Brittany Sattler <bmsa...@ucdavis.edu> wrote:
I am new to google sheets and can't figure out this one.--I have two x value columns and one y column that corresponds to both x columns. I am able to format the graph with one x column and multiple y's, but does anyone know how to do the opposite??Thanks!
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/97368e71-3e88-472b-a350-127d41d223be%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
----
•
Sergey Grabkovsky
•
Software Engineer
•
Google, Inc
•
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/9b082909-ce17-4a4b-ae5e-ed6cab11d096%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
•
Sergey Grabkovsky
•
Software Engineer
•
Google, Inc
•
--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/91e1b466-45e0-489f-8a75-97a899e90301%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages