| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Area Chart With Value X-Axis?
Area charts in Excel come up with a category axis for the X-axis, so that
points are evenly-spaced, regardless of value (the value is disregarded). Is there a way to create an area chart with a value axix for the X-axis, so that points are spaced according to their values? The solution need not be something that strictly qualifies as an area chart, as long as it looks like one. Add-ons, etc., are just fine, as well. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Area Chart With Value X-Axis?
You can use a time-scale axis, which is a good approximation:
http://peltiertech.com/Excel/Charts/XYAreaChart.html http://peltiertech.com/Excel/Charts/XYAreaChart2.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim Skrydlak" wrote in message ... Area charts in Excel come up with a category axis for the X-axis, so that points are evenly-spaced, regardless of value (the value is disregarded). Is there a way to create an area chart with a value axix for the X-axis, so that points are spaced according to their values? The solution need not be something that strictly qualifies as an area chart, as long as it looks like one. Add-ons, etc., are just fine, as well. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Area Chart With Value X-Axis?
I'll give that a try. In this case, the X-axis is a set of percentages,
representing the standard deviation of an investment portfolio. You've certainly headed me in a direction that should prove helpful. Thank you. Jim "Jon Peltier" wrote: You can use a time-scale axis, which is a good approximation: http://peltiertech.com/Excel/Charts/XYAreaChart.html http://peltiertech.com/Excel/Charts/XYAreaChart2.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim Skrydlak" wrote in message ... Area charts in Excel come up with a category axis for the X-axis, so that points are evenly-spaced, regardless of value (the value is disregarded). Is there a way to create an area chart with a value axix for the X-axis, so that points are spaced according to their values? The solution need not be something that strictly qualifies as an area chart, as long as it looks like one. Add-ons, etc., are just fine, as well. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Y-Axis Problem With Area Chart | Charts and Charting in Excel | |||
| Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
| How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
| Vary colors in area chart by x-axis value | Charts and Charting in Excel | |||
| Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Linear Mode
