ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   XY Chart with Colored Quadrant Background AND variable Axes (https://www.excelbanter.com/charts-charting-excel/126907-xy-chart-colored-quadrant-background-variable-axes.html)

claudio

XY Chart with Colored Quadrant Background AND variable Axes
 
I have an XY chart with 30 points (each a single serie, so that I can name
the point). I would like to have a colored quadrant background to group the
points (like a BCG matrix). The lines of the background must be the average
of the points for each axes. The problem is that this normally requires the
axes to start at zero. My points, however, are usually between 80% and 100% -
but not allways.
I did not find a way the make the axes start at a value I define depending
(dynamically) on the data points.

Anybody got an idea, maybe a page?
Peltier has no solution to that.

ShaneDevenshire

XY Chart with Colored Quadrant Background AND variable Axes
 
Hi,

Well I think I understand part of your question. I have created a colored
quadrant background with and XY chart, however, I am not clear about the
variable Axes thing.

I also don't know how to attach a sample file so you can comment on it. Let
me know if you want me to send you a copy.

--
Thanks,
Shane Devenshire


"claudio" wrote:

I have an XY chart with 30 points (each a single serie, so that I can name
the point). I would like to have a colored quadrant background to group the
points (like a BCG matrix). The lines of the background must be the average
of the points for each axes. The problem is that this normally requires the
axes to start at zero. My points, however, are usually between 80% and 100% -
but not allways.
I did not find a way the make the axes start at a value I define depending
(dynamically) on the data points.

Anybody got an idea, maybe a page?
Peltier has no solution to that.



All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com