melting of two and more columns

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
 
J

Jon Peltier

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/
_______
 
J

juergenkemeter

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
 

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
Problem with Excel 2007 clustered column chart on log scale 1
Is it possible to filter the data inside the series command? 2
How do I create a combined 'cluster' and 'stacked' column chart? 1
Column chart with additional "average" column 1
How to create a bubble chart with more than 2 variables 0

Top