2 Replies - 1048 Views - Last Post: 24 August 2011 - 04:20 AM

#1 chrisH  Icon User is offline

  • D.I.C Head

Reputation: 12
  • View blog
  • Posts: 62
  • Joined: 26-July 11

Best way to plot the following data?

Posted 23 August 2011 - 03:08 PM

Hi,

[I didn't know where to post this so I figured here would be...casual]

I've been assigned the task of some basic data analysis. The higher ups like to see charts for when I generate the reports. So far, this has worked well. The latest report has me scratching my head about how to present it though.

The report, in some instances, requires me to plot ~50 series of data. Attached is a sample picture of what it could look like if I were to use a bar graph approach. Ugly, right?

What do you think would be the best way to plot a lot of data series?

I might want to add that I am limited to the following (reporting software gives me these options only):
Pie Chart, Bar Graph, Stacked Bar, Line Graph, Area Graph, Stacked Area, Scatter, Bubble, High-low, Candlestick, Gantt, Multiaxis(combining any of the previous options as many times as I like into 1 graph).

Edit: Forgot to attach image.

Attached image(s)

  • Attached Image

This post has been edited by chrisH: 23 August 2011 - 03:09 PM


Is This A Good Question/Topic? 0
  • +

Replies To: Best way to plot the following data?

#2 creativecoding  Icon User is offline

  • Hash != Encryption
  • member icon


Reputation: 928
  • View blog
  • Posts: 3,212
  • Joined: 19-January 10

Re: Best way to plot the following data?

Posted 23 August 2011 - 05:10 PM

No idea what sort of data you are presenting, so I'll take a guess at a line graph!
Was This Post Helpful? 0
  • +
  • -

#3 cfoley  Icon User is offline

  • Cabbage
  • member icon

Reputation: 2069
  • View blog
  • Posts: 4,307
  • Joined: 11-December 07

Re: Best way to plot the following data?

Posted 24 August 2011 - 04:20 AM

You really want a single chart that tells the story, or at least the important parts.

How about get the mean and SD of "92.500". Do the same for each of the other categories. This will give you a single line chart with error bars.

If you are looking at trends through time have each category in your key as a series. You can show as few or as many of the series as is useful.

This post has been edited by cfoley: 24 August 2011 - 04:21 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1