melting of two and more columns

  • Thread starter Thread starter juergenkemeter
  • Start date Start date
J

juergenkemeter

Hi,
I have an Excel chart with several columns of different height.
Is there a way to combine these columns to ONE column which represents
their average height/value?

Thx for any help,
Jurgen
 
Can you be more specific about the data that you have?

"juergenkemeter"
 
Can you calculate the average in the worksheet and plot that value?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Hi,
that works fine. But then I have another problem: I have to draw the
STDEV of these values into this one column...
Jürgen
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

scaling of columns: same maximum height despite different ranges 2
Different widths for each column in a 100% stacked column chart 1
Excel Comparing two columns 1
How do I plot a column average ? 1
How do I create a combined 'cluster' and 'stacked' column chart? 1
Clustered column with 2 different Y-axis 2
Is it possible to filter the data inside the series command? 2
Column chart with additional "average" column 1

Back
Top