Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 3rd 06, 04:51 PM posted to microsoft.public.excel.charting
cfagan
 
Posts: n/a
Default Sub-Categories for X-axis labels, line on bar chart?


I am making a vertical bar graph for pH solutions of various drug
reagents. I would like to graph all my results on one chart.
Preferrably, with the drug as the group label on the x-axis with
multiple samples in each group. For example, samples 2, 36, and 45 I
would like their resulted pH plotted in the coc group and samples 5,17,
and 29 I would like their pH's plotted in the amp group. The chart
should show the drug groups on the x-axis with the sample names
directly on the bar itself. Just to complicate this a little further,
I would also like to plot a min and max line for each drug group on
this bar chart. How can I do this? Thanks in advance for any help.


--
cfagan
------------------------------------------------------------------------
cfagan's Profile: http://www.excelforum.com/member.php...o&userid=32118
View this thread: http://www.excelforum.com/showthread...hreadid=518747


  #2   Report Post  
Old March 3rd 06, 06:01 PM posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default Sub-Categories for X-axis labels, line on bar chart?

To address the first part of your problem...

Assuming the data are organized in 3 columns as:
Group Sample Result
all you need to do is create a PivotTable w/an associated PivotChart (Data |
PivotTable and PivotChart Report...) Put the group and the sample as the 2
row fields and add the result as the data field.

--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"cfagan" wrote:


I am making a vertical bar graph for pH solutions of various drug
reagents. I would like to graph all my results on one chart.
Preferrably, with the drug as the group label on the x-axis with
multiple samples in each group. For example, samples 2, 36, and 45 I
would like their resulted pH plotted in the coc group and samples 5,17,
and 29 I would like their pH's plotted in the amp group. The chart
should show the drug groups on the x-axis with the sample names
directly on the bar itself. Just to complicate this a little further,
I would also like to plot a min and max line for each drug group on
this bar chart. How can I do this? Thanks in advance for any help.


--
cfagan
------------------------------------------------------------------------
cfagan's Profile: http://www.excelforum.com/member.php...o&userid=32118
View this thread: http://www.excelforum.com/showthread...hreadid=518747




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
make line in chart start at y axis Tone Charts and Charting in Excel 1 May 5th 05 09:23 AM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM
How do I change x axis values in a line chart? Elizabeth Charts and Charting in Excel 1 March 29th 05 11:05 AM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 04:09 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 03:46 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017