Pyramid Chart - Additional Data
Hi
I've created a pyramid chart and now wish to add two further data series that I am attempting to display as lines running vertically to show a comparator for each bar on my pyramid. It can be achieved by adding a trendline but when adding additonal data changing to a line chart, the lines are displayed horizontally on a secondary axis. Does anyone know of a way of resolving this? Thanks |
Hi Mark,
Does this help? http://www.andypope.info/ngs/ng3.htm If not can you explain how you created the pyramid chart. Cheers Andy Mark wrote: Hi I've created a pyramid chart and now wish to add two further data series that I am attempting to display as lines running vertically to show a comparator for each bar on my pyramid. It can be achieved by adding a trendline but when adding additonal data changing to a line chart, the lines are displayed horizontally on a secondary axis. Does anyone know of a way of resolving this? Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Mark -
A pyramid chart is a horizontal bar chart. A line chart series can be used with a column chart, because they both plot values vertically and categories horizontally. You can use an XY chart series, using the bar chart value axis (horizontal) for the XY series X value axis, and the bar chart category axis (vertical) for the Y values. The technique is described he http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html This page shows several XY series on a horizontal bar chart: http://peltiertech.com/Excel/Charts/BarLineCombo.html and in this article I show how to use an XY series to place markers onto a Gantt chart, which is another horizontal bar chart: http://peltiertech.com/Excel/Charts/GanttChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mark wrote: Hi I've created a pyramid chart and now wish to add two further data series that I am attempting to display as lines running vertically to show a comparator for each bar on my pyramid. It can be achieved by adding a trendline but when adding additonal data changing to a line chart, the lines are displayed horizontally on a secondary axis. Does anyone know of a way of resolving this? Thanks |
All times are GMT +1. The time now is 08:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com