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 |
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 |
All times are GMT +1. The time now is 04:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com