| T O P I C R E V I E W |
| GThreep |
Posted - 01/29/2016 : 06:59:10 AM
Origin Ver. and Service Release: OriginPro 9.1.0 (64bit) Sr3
Operating System: Windows 10
Hi,
I'm trying to make a column graph, in which each column aggregates the data for a range of the underlying data. TO explain better: my data has abscissa increments of 0.05; I'd like the values corresponding to x = 0.05, 0.1, 0.15 ... 0.95 to be summed together and displayed as a single column. How can I do this?
Thanks GT |
| 2 L A T E S T R E P L I E S (Newest First) |
| GThreep |
Posted - 01/30/2016 : 08:29:57 AM
Thanks for the nice answer! It's not exactly what I wanted; the difference is I have x = 0, 0.1, 0.2 ... and the aggregated columns would be x = 0 to 1, 1 to 2, .... But I think "reduce by group" instead of reduce duplicated data will work. |
| Hideo Fujii |
Posted - 01/29/2016 : 4:02:45 PM
Hi GT,
I'm not sure if I understood correctly what you wanted...
Anyway, let me describe the steps to create the graph like:
from the data something like:
Steps:
1) To aggregate by the same X values, run "Analysis: Data Manipulation: Reduce Duplicated X Data"
menu. Set the "Replace Y With" to "Sum", and "Output" to "<new>!(<new>,<new>)" for the new sheet.
This creates the aggregated sheet:
2) Run "Worksheet: transpose" menu with options: Label Type=Long Name, Data=First Column,
Output Worksheet=<new> for the new sheet. Move the Comment to the first column.
This creates a flat worksheet like:
3) Highlight the worksheet, and run "Plot: Column/Bar/Pie: 100% Stacked Bar" menu.
Customize the produced graph (e.g., change the aspect ratio, remove the axis, change the label format
like %(wcol(n)[L]$) to show the X values in the bars, the legend, etc.).
Now, you get the graph like above.
--Hideo Fujii
OriginLab |
|
|
