Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding labels to a waterfall BAR chart
Chaps,
I've got a waterfall chart which is based on bars, not on columns. I.e. the bars run from left to right. This is fine until I try to add the labels, which using the Peltier method involves adding an invisible line series. And here's where the problem arises. Excel only does line charts horizontally, not vertically, so I can't put it onto my waterfall. Anybody got any ideas? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding labels to a waterfall BAR chart
Hi,
Instead on Line series use an XY-scatter series. This will allow you to control both the horizontal and vertical position of the labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... Chaps, I've got a waterfall chart which is based on bars, not on columns. I.e. the bars run from left to right. This is fine until I try to add the labels, which using the Peltier method involves adding an invisible line series. And here's where the problem arises. Excel only does line charts horizontally, not vertically, so I can't put it onto my waterfall. Anybody got any ideas? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding labels to a waterfall BAR chart
For ideas on placing the XY points, look at the example of Dot Plots he
http://peltiertech.com/Excel/Charts/DotPlot.html or the example of advanced Gantt charts with labels he http://peltiertech.com/Excel/Charts/GanttChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, Instead on Line series use an XY-scatter series. This will allow you to control both the horizontal and vertical position of the labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... Chaps, I've got a waterfall chart which is based on bars, not on columns. I.e. the bars run from left to right. This is fine until I try to add the labels, which using the Peltier method involves adding an invisible line series. And here's where the problem arises. Excel only does line charts horizontally, not vertically, so I can't put it onto my waterfall. Anybody got any ideas? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding labels to a waterfall BAR chart
Thanks Andy.
I've tried this and it doesn't seem to work as whilst my waterfall runs on one axis, the scatter still insists on running perpendicular to it. Cheers, Tom. "Andy Pope" wrote: Hi, Instead on Line series use an XY-scatter series. This will allow you to control both the horizontal and vertical position of the labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... Chaps, I've got a waterfall chart which is based on bars, not on columns. I.e. the bars run from left to right. This is fine until I try to add the labels, which using the Peltier method involves adding an invisible line series. And here's where the problem arises. Excel only does line charts horizontally, not vertically, so I can't put it onto my waterfall. Anybody got any ideas? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding labels to a waterfall BAR chart
Even when you provide X values that match the bar values and a equi spaced Y
values? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... Thanks Andy. I've tried this and it doesn't seem to work as whilst my waterfall runs on one axis, the scatter still insists on running perpendicular to it. Cheers, Tom. "Andy Pope" wrote: Hi, Instead on Line series use an XY-scatter series. This will allow you to control both the horizontal and vertical position of the labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message ... Chaps, I've got a waterfall chart which is based on bars, not on columns. I.e. the bars run from left to right. This is fine until I try to add the labels, which using the Peltier method involves adding an invisible line series. And here's where the problem arises. Excel only does line charts horizontally, not vertically, so I can't put it onto my waterfall. Anybody got any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Waterfall Chart | Charts and Charting in Excel | |||
Horizontal lines in waterfall chart | Charts and Charting in Excel | |||
Waterfall chart add-ins? | Charts and Charting in Excel | |||
waterfall chart ... once again ... | Charts and Charting in Excel | |||
negative waterfall chart | Charts and Charting in Excel |