Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
isioma
 
Posts: n/a
Default How to show multiple data sets on one bar chart

I'm trying to compare three different values in four sets of
individuals-female and male locusts and human beings. I'd like to plot the
power/mass, velocity and acceleration alues for these three on the same
x-axis, but the range of values (300-3) makes the graph look distorted unless
blown up. Also error bars cannot be seen. Help please!!!
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default How to show multiple data sets on one bar chart

You could normalize your data on a scale of 0 to 1, where 1 is the max of a given
parameter across all of your data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

isioma wrote:

I'm trying to compare three different values in four sets of
individuals-female and male locusts and human beings. I'd like to plot the
power/mass, velocity and acceleration alues for these three on the same
x-axis, but the range of values (300-3) makes the graph look distorted unless
blown up. Also error bars cannot be seen. Help please!!!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart or scatter chart?? rmellison Charts and Charting in Excel 17 February 10th 10 11:03 AM
"propagating" a chart across a number of data sets rgraham1 Charts and Charting in Excel 5 October 23rd 05 04:10 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Combination chart with three data ranges Joe Mac Charts and Charting in Excel 2 July 11th 05 11:00 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"