Multiple Series Column Chart

[Sean]

Is it possible to produce column (or bar) charts with multiple series.
An example would be this medal count set http://www.swivel.com/data_sets/show/1016370
which only seems to be able to show gold or silver or bronze rather
than all three.

[Sean Carmody]

I've worked out how to do this using the "compare" function.
Sean.

[Sean]

Now I have a related question. Having created the multiple series bar
chart using compare, is there any way for the resulting chart to
appear in the "Popular Graphs" section of the underlying data set? The
example I am looking at is http://www.swivel.com/graphs/show/29155577

Sean.

On Aug 10, 4:45 pm, "Sean Carmody" <seancarm...@gmail.com> wrote:
> I've worked out how to do this using the "compare" function.
> Sean.
>

[Sean]

Another question! Is there any way to sort by all three series on the
chart not just the first one ("Gold")?

[natalie]

Hi Sean,

Typically, the popular graphs that show up on the data set page are
the graphs that have the most views. It looks like there was a bug in
the system. Our engineers fixed the problem today, so your graph on
Olympic medals should now show up on the data set overview page.

In response to your question about sorting by series, Swivel doesn't
currently support that feature. You can, however, sort the entire
chart by highest, lowest, or alphabetically. To do so, just click on
the "more options" link above the graph, and you can play around with
sorting the graph that way.

You can also sort the columns individually in the table view (http://
www.swivel.com/data_columns/spreadsheet/8970552) by clicking on the
the column header.

Hope this helps! If you have any other questions, please let me know.
We're always working to make Swivel better and we really appreciate
your feedback.

Best,
Natalie Glatzel
Swivel.com

[Sean Carmody]

Thanks for the reply Natalie. As you can tell from my recent activity, I am certainly enjoying playing around with Swivel!

As far as the sorting is concerned, I tried (with the Olympics example) fudging it by uploading the data sorted in the order I wanted and then setting "more options" sort to "original". Even with this setting, the chart was by alphabetical order of country rather than the order in the table view.

Anyway, keep up the good work!

Regards,
Sean.

[natalie]

Hi Sean,

I know -- Thank you for all of your great feedback!

When you uploaded the data sorted again, was it the columns (gold,
silver, bronze) that you were trying to sort differently? Or the
order of the countries on the chart?

Best,
Natalie

On Aug 12, 6:21 pm, "Sean Carmody" <seancarm...@gmail.com> wrote:
> Thanks for the reply Natalie. As you can tell from my recent activity, I am
> certainly enjoying playing around with Swivel!
>
> As far as the sorting is concerned, I tried (with the Olympics example)
> fudging it by uploading the data sorted in the order I wanted and then
> setting "more options" sort to "original". Even with this setting, the chart
> was by alphabetical order of country rather than the order in the table
> view.
>
> Anyway, keep up the good work!
>
> Regards,
> Sean.
>

[Sean Carmody]

Natalie,

At the moment the data actually has a slightly complicated sort: descending by score, which is 3 x no. Gold + 2 x no. Silver + No. Bronze (that's how it's currently sorted).  An alternative which would be to sort by Gold then Silver then Bronze.

Sean.