Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Two axis- is it possible to have one bar and one point?
hi, i have created a BAR chart(horizontal) and have two series of data with two axis at top and bottom. I would like on of the data series not to be represented with a bar but with a point, like on a scatter graph. Is this possible, and if so, please could you let me know asap how to do this. Important bit of work being carried out. Thank you so much for your time. -- londonal ------------------------------------------------------------------------ londonal's Profile: http://www.excelforum.com/member.php...o&userid=15133 View this thread: http://www.excelforum.com/showthread...hreadid=543289 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Two axis- is it possible to have one bar and one point?
A "line" chart cannot be oriented with its category vertical, that is,
parallel to the bar chart's. However, you can use an XY series type, with the source data for the X and Y as appropriate to a horizontal X axis, and using various scaling factors to assure correspondence of the two series. This example may help: http://peltiertech.com/Excel/Charts/BarLineCombo.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "londonal" wrote in message ... hi, i have created a BAR chart(horizontal) and have two series of data with two axis at top and bottom. I would like on of the data series not to be represented with a bar but with a point, like on a scatter graph. Is this possible, and if so, please could you let me know asap how to do this. Important bit of work being carried out. Thank you so much for your time. -- londonal ------------------------------------------------------------------------ londonal's Profile: http://www.excelforum.com/member.php...o&userid=15133 View this thread: http://www.excelforum.com/showthread...hreadid=543289 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|