Find solution
How to create column chart with Google charts?

Google Spreadsheets / Charts Help

  • Let's say I have a two column chart, with the following values: Col. 1..........Col. 2 -------...-------- 2.................A 5.................A 7.................C 1.................B 9.................C ... ... Without sorting (i.e., automatically), I would like to be able to, for example, plot all values of column 1 for which column 2="C". Preferably in Google Spreadsheets. I guess what I'm looking for is a way to incorporate logic functions into charts. Does anyone know how to do this, or can you recommend software that can? I'm using Google Forms to compile user-entered data into a spreadsheet and then would like to display that visually, broken down by different categories. Thanks for any advice.

  • Answer:

    Whoops...sorry. I guess that column layout didn't work. The basic idea is that column 1 has numerical data in it and column 2 has categorical data (i.e., A, B, or C).

underdetermined at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

I haven't used Google spreadsheets, but I think a http://docs.google.com/support/spreadsheets/bin/answer.py?answer=92022&query=filter&topic=&type=is what you want.

echo target

You mean filter the original data into another worksheet and then use that as the source data for the plot?

underdetermined

Maybe. I don't know Google's app well enough to say. Perhaps someone else has done this successfully.

echo target

If I understand what you're asking, pivot charts in Excel would do it. Not sure what the possibilities are through Google docs but you could try searching their help/talk sections with the pivot chart term.

yarrow

I don't know of any basic spreadsheet programs that will allow you to enter formulas as the range for a chart. Certainly not Excel, Numbers, or Google Spreadsheets. You're going to have to use filters or formulas on the data itself and then plot the output.

junesix

Assuming that you want to display the distribution of Column 1 for different values of Column 2: In stata, this would be as simple as kdensity column1 if column2=="C" [if you like kernel densities] Or even histogram column1, by(column2) [or something very similar, if you like histograms] stata is very not free. stata is not a spreadsheet.

ROU_Xenophobe

If you have excel, play around with the pivot chart function. If you drop Col 1 into the data area and both col 1 and col 2 into the category area, you'll get something close to what you're asking for in this example. You can then use the little drop down arrow in the category area by the col 2 label to filter for the Cs. If the values in Col 1 aren't unique, you might want another column of data that is unique to use for the category axis instead so that you don't wind up grouping by col 1 values. Anyway, mess around, it may do what you're aiming at.

yarrow

Maybe I'm not understanding the question correctly - could you select all the data in both columns, sort by column 2 in ascending order, and select the data you need to plot a graph from?

Phire

ACK. Disregard answer. I completely missed the bit about not sorting, apologies.

Phire

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.