plot and error bars

[jaime aburto]

Hi

I’m trying to plot monthly variables, and ad an error bars to this variable. I have this type of data set and I want to do this graphic (see pics). Plot the average by months and show also the years.

Thanks!

[dgteam]

Try using the Pivot command and set the Rows to your date column and set Map rows to ‘Monthly’. To help show how, we uploaded a new example file to illustrate with similar time series data called ‘KEY WEST WATER TEMPERATURE’.

With your data spanning several years you should see the month and year on the x-axis in DataGraph when you plot. Does this help?

 

[jaime aburto]

Many thanks, almost work!!!!

I have some little problem. The dates for the different graphs  don’t match. The first column of raw values are from the plot graph and the dates of the second row values (extracted from pivot for anual values). As the starting and fishing dates do not matches both graphics are displaced. Some idea how to fix it? I tried to change the values from columns, but didn’t work.

Best, Jaime

 

[dgteam]

Yes – this is an issue when you want to plot the raw data with the dates.

We were doing an offset to look correct, but thought about an even better way.  Basically, you take the average of the date, so both the Row for grouping and the Value are set to the same date column.

When you extract that result, this can be used now for the x-axis.  We updated the example file to use this approach too.  So you can take a look at the details there. Does this work for you?

[stephvazgal]

Hello,

This 1st graph was made in Origin, how can I make a similar graph in datagraph Is it posible for me to remove the numbers on the vertical axis, how can I make the plot Line thicker, can I move the plot Lines up or down?

 

Hope for your responce,

S.

[dgteam]

You can turn off the Y axis using the checkbox for Draw y numbers.  Here’s a simple example using the Plots command this has a setting for the line with that will change all the lines and also an officer that you can use to separate the lines. Here is a screenshot with those options circled.