ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to show multiple data sets on one bar chart (https://www.excelbanter.com/charts-charting-excel/54736-how-show-multiple-data-sets-one-bar-chart.html)

isioma

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!!!

Jon Peltier

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!!!




All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com