It’s relatively easy to apply conditional formatting in an Excel worksheet. It’s a built-in feature on the Home tab of the Excel ribbon, and there many resources on the web to get help (see for example what Debra Dalgleish and Chip Pearson have to say). Conditional formatting of charts is a different story.
People often ask how to conditionally format a chart, that is, how to change the formatting of a chart’s plotted points (markers, bar fill color, etc.) based on the values of the points. This can be done using VBA to change the individual chart elements (for example, VBA Conditional Formatting of Charts by Value), but the code must be run whenever the data changes to maintain the formatting. The following technique works very well without resorting to macros, with the added advantage that you don’t have to muck about in VBA.
Unformatted Charts
Here is the simple data for our conditional chart formatting example.
The data makes a simple unformatted bar chart. . .
. . . or a simple unformatted line chart.
We want our charts to show different colored points depending on the points’ values.
Except for some simple built-in formats, conditional formatting of worksheet ranges requires formulas to determine which cells should take on the formatting. In the same way, we will use formulas to define the formatting of series in the charts.
We will replace the original plotted data in the line and bar charts with several series, one for each set of conditions of interest. Our data ranges from 0 to 10, and we will create series for each of the ranges 0-2, 2-4, 4-6, 6-8, and 8-10.
Conditional Formatted Bar Chart
The data for the conditionally formatted bar chart is shown below. The formatting limits are inserted into rows 1 and 2. The header formula in cell C3, which is copied into D3:G3, is
=C1&"<Y<="&C2The formula is cell C4 is
=IF(AND(C$1<$B4,$B4<=C$2),$B4,"")The formula shows the value in column B if it falls between the limits in rows 1 and 2; otherwise it shows an apparent blank. The formula is filled into the range C4:G13.
When the bar chart is selected, the chart’s source data is highlighted as shown.
We need to change the source data, removing column B and adding columns C:G. This is easily done by dragging and resizing the colored highlights.
The chart now shows five sets of colored bars, one for each data range of interest. It’s not quite right, though, since it’s a clustered bar chart, and each visible bar is clustered with four blank values.
This is easily corrected by formatting any one of the bars, and changing the Overlap property to 100%. This makes the visible bars overlap with the blank bars.
Conditionally Formatted Line Chart
The data for the conditionally formatted bar chart is shown below. The formatting limits are inserted into rows 1 and 2. The header formula in cell C3, which is copied into D3:G3, is
=C1&"<Y<="&C2The formula is cell C4 is
=IF(AND(C$1<$B4,$B4<=C$2),$B4,NA())The formula shows the value in column B if it falls between the limits in rows 1 and 2; otherwise it shows an error, #N/A, which will not be plotted in a line chart. The formula is filled into the range C4:G13.
When the line chart is selected, the chart’s source data is highlighted as shown.
We need to expand the source data, keeping column B as a line connecting all points and adding columns C:G for the separately formatted series. This is easily done by resizing the colored highlights.
The chart now shows five sets of colored markers and line segments, one for each data range of interest.
A little formatting cleans it up. Remove the markers from the original series, remove the lines from the other series, and apply distinct marker formats to the added series.
Remove the unneeded legend entry (for the gray line) by clicking once to select the legend, clicking again to select the label, and clicking Delete.
Conditional Formatting Flexibility
This simple example has formatting formulas defined based on the Y values in the chart. It is possible to define formatting based on Y values, X values, or values in another column which is not even plotted. As in worksheet conditional formatting, the only limit is your own ability to construct formulas.
This technique works on most useful Excel chart types, including bar and line charts shown here, and XY charts as shown in Conditional XY Charts Without VBA.
Hi Jon,
I like this technique. I have an immediate use for this approach with showing statistical outliers on xy charts.
On the off scale or suspect points, I’ve set the points to be labelled and use the big circular point markers. It makes the point of calling out the bad in the context of the good.
Thanks
Bob
Nice stuff. I did something similar with a scatterplot where I built myself a tool that takes X &Y data and bins it according to some z-axis variable. I made the plot flexible so I could go up to 10 z-variable bins. That allowed me the ability to add a trend line for each bin.
Hi, You always have exellent posts, easy to follow and spot on. I do have a question on this one. I need to plot a comparison between forecast and baseline numbers, I’m using a bar chart. If the variance is x, the forecast bar should be red, if between x and y, it’s yellow, and over y, it’s green. I can do this with the non-vba process above, but here’s the catch. I want the forecast to overlap but not the baseline. I’ve tried using a second axis but the yellow (the middle value) overlaps with the baseline. Any thoughts??
Thanks!
Charlene -
Are you plotting baseline and forecast together? I don’t know what you mean about overlapping.
Thanks for responding. My intent is to have two bars per project, one is the baseline cost and the other the forecast cost. As you suggested, I set up three different series for the forecast cost so that the bar can be green, yellow or red based on the difference from baseline. My problem is that I end up with spaces for the empty series, and if I overlap, it also overlaps with the baseline bar (which I don’t want.) If I still am not making sense I can email you the chart in the morning, it’s on my work laptop.
Thanks again.
Charlene -
Oh, I get it. When you overlap the conditional columns by 100%, it overlaps all columns.
You need to follow a more intricate protocol. I’ve written a tutorial called Clustered and Stacked Column and Bar Charts. You need to set up such a chart, with one column clustered next to a stack of three coumns, and those three columns are the red-yellow-green.
In other words, in the other article, in the table that has Q1 Actual, Q2 Actual, Q1 Budget, Q2 Budget, with the two actual values in the same row, and hte two Q2 values staggered one row lower, You would have:
where Budget is in one row, and the red, yellow, and green conditional Forecast values are in the next. The chart looks like there’s only one of the conditional columns in each slot, because the zero-height bars don’t appear.
Oh yeah, you might consider adjusting the red/green color scheme, for the 10% of the males in your audience with color vision deficiencies.
Hi Jon – great post! How would you set something like this up for an XY Scatter that is being used as a 2×2 matrix to plot Ease (y-axis) against Benefit (x-axis)? I’m looking to do two things:
1. Change the color of the marker based on which quadrant the data plots to
2. Change the type of marker based on another variable that I will specify in one of the columns along with the data (e.g. Finance, HR, Sales)
Thanks,
Steve
This was a great directional idea. I applied the same logic to scatter plot charts and the results were exactly what we wanted to do. It really helped to visually see range of stores in color based on their tiering. So many uses for this approach. Glad I stumbled across it and so glad someone took the time to both show and explain the approach. Awesome article.
So how would I change the colour of a value if it goes above a target value. for example:
Week Target Value
1 10 9
2 10 8
3 10 13
4 10 5
Thus plotted on a line graph any value above the target value would display in red and any value below target value would display in green
Thanks
Stuart -
It’s actually easier than the line chart example above.
Here is your data, with two more columns. The formula in column D displays a number if the value is less than or equal to the target, while the formula in column E displays a number if the value exceeds the target.
I plotted all columns. The Target and Value columns are plotted as lines, while the Below and Above columns are plotted as distinct markers.
I’m trying to display tank volumes, in gradients of green to yellow to red. Using Conditional Formatting, my data cells depict it nicely. However, how can I also see similar gradiation in my bar chart? I’m unable to get beyond manually coloring each bar to correspond to its data cell. Won’t Excel color the bars just like it colors the data cells?
Thank you!
Mac -
If Excel colored its charts the way it colors the cells, I would not have had to write this article.
If you need some kind of gradient, you could figure out how RGB values vary with your tank volumes, and write some kind of VBA to handle that. In fact, if you are willing to share your workbook (jon at peltiertech dot com), I could put it on my list of articles to write.
Hi there,
I was wondering if you could conditionally format 100% stacked bar charts. I am trying to create a tracking tool for NPS and would like to use the colours red , green and yellow.
Regards,
Richard
I am trying to make a graph showing order time and how long the deliver took. I have column a “order time” and b “deliver time”. i wanted to make column c “# of guests” and in my legend i wanted to make it:
1 GUEST
2 GUESTS
3 GUESTS
4 GUESTS
5+ GUESTS
i was wondering if there was a way for my graph to have the different # of guests different colors when plotted. thanks.
So thankful for your help! Really! This is so important to a project we are working on right now – a customer deliverable and am SO GLAD not to have to do VB.
Jon,
Is there a way to also show data labels conditionally?
ie – the chart colors update beautifully, I have 4 bars and parameters on each bar that apply the chosen color for that range. But when I show data labels, there are 4 on each bar (I can see the logic of this) but only want 1 data label displayed per range. Can this also be done without VBA or manual work?
Jen
Novice excel 2003 user here trying to develop a line chart for the following: I have monthly data for the S&P 500 index since 1890, separated in two series, one is the average monthly close, the other is an exponential moving average of the same data. I would like to show the monthly line as one color when it crosses above the EMA, and another color when it crosses below the EMA.
Can anyone help?
Hi Jon,
Is there a way to do conditional format on staked bar and 100% stacked bar
Thanks for your support,
Marc
Marc -
These routines do not care whether the chart is stacked or clustered, column or bar. It’s up to you to be creative with your formulas.
Hi Jon,
I have a stacked bar chart with 4 series. I want to be able to conditionally format each of them.
When doing conditional formatting on stacked bar, the series that meets the formatting condition starts from 0% and not from its original position (>0%)
I tried following your methods and was able to drag and resize top header but when I tried to resize data labels [blue lines] it wouldn’t let me resize that to capture the formula’s I had put in.
Suggestions?
Hi Jon,
Could You please share the excel sheet wherefrom you formatting graph ?
Because I tried your method but unfortunately things are not working for me; I want to see where I am going wrong.
My excel version MS2007!
Hi Jon
I loved your tip about using other objects as point markers.
I chart wind speed and direction and was looking to place arrows on the chart points that align with the wind direction. Your tip got me started.
I wrote a macro that used the down arrow from the autoshapes and rotated it according to the wind direction then pasted it to the chart point. I made this into an addin which I can use on any chart with a wind speed series.
It looks great and communicates the information extremely well.
Thanks
Fred
Jon,
Awesome tip on this. I have a linked spreadsheet that I produce graphs off of. The problem is I have all my values in one column that I cannot change around without causing problems many other places. The autoformat already changes the colors of the values in the cell based on their values. The current chart uses column A as the serial identifier on the x axis. How can I get it to automatically change the bar color based on the autoformat color of the cell it is linked. This chart deals with individual serial aircraft and hours until inspection.
Thanks
Robert
Robert -
Seems like you could use the approach in VBA Conditional Formatting of Charts by Category Label.
not really a comment but a request.
i have a series of datasheets for different materials. each sheet has a significant amount of data, 1000′s, against time. so i can plot the variables against time, no problem. i also plot the data for one variable for each material, slighty harder because each series refers to a different sheet. what i would like to is displayed data values for specific x values. i can dsiplay all labels but obviously there are 1000′s.i want to be able to specify the x value, say 30 seconds, not datapoint and get a y value for all series on the chart (scatter plot). any clues gratefully recieved. thks
Martin -
Check out Excel Interpolation Formulas.
I have followed your steps but when I actually expand the Y series from one column to 4 columns, it gives me separate series for each of the columns. Any advise?
Kate -
That is what is supposed to happen. Each series is then formatted uniquely. When a value changes, the value moves from one column to another based on the conditions written into the formulas.
Hi Jon,
Thank you for maintaining this great website. I’ve come here many times in the past seeking advice and tricks to improve my worksheets. This time however I do have a question that I was not able to find the answer to….
Time is what I am working on: http://i45.tinypic.com/orrzpv.png
What I would like is to have the portion of the column that surpasses the 100% mark to change to a different color, is this possible? For example if the column reaches 101%, the first 100% would remain green and the 1% above it would be red.
Thanks is advance.
Steve
Steve -
Make a stacked column chart, with two series. The green series uses formulas to plot MAX(Value,100%), and the red series on top of it uses formulas to plot MAX(Value-100%,0).
Hi Jon,
Very nice, it helped me a lot. I only have one issue left. I would like to have the value on the chart. When I do that it shows #N/A for the series that of course is empty. Can you remove that?
Lars
Lars -
If it’s a bar chart, replace #N/A or NA() in the cells with “”.
I have a two raws of logarythmic data and want to produce a conditional scatter plot:
A 1.76 .31
B 1.66 .46
C 2.47 .63
D 1.81 .27
E 2.34 .32
Do you have a question? Did you try and get stuck?
Hi!
I have a simple table with 10 categories and 10 numbers corresponding to it. So, the graph has 10 bars and under each bar it’s the name of the category. So… I want to automatically color the bars in different colors depending on the category. For instance, each time I write “House” as a category, the bar should get yellow. And so on..
Anybody has an idea how to do it?
Hope you understand my problem. And thanx :)
Hi Jon,
I appreciate you posting this technique, it is quite helpful. However, I am having difficulty modifying this approach to work with my data. I would like to use a line or scatterplot chart, but instead of plotting conditionally formatted markers, I would like one continuous line to show the formatting. The data are a daily time series of stream temperature and are categorized as below average, average or above average.
Here is an example:
Date Temperature Category (as numerical value)
1/1/2011 14.5 1
1/2/2011 15.3 1
1/3/2011 16.9 2
1/4/2011 15.6 1
1/5/2011 14.8 1
1/6/2011 12.3 0
1/7/2011 12.6 0
1/8/2011 11.3 0
1/9/2011 14.2 1
1/10/2011 14.8 1
Using your suggestion but removing the markers and keeping the lines results in a connection between dates (e.g. 1/5 data point connected to 1/9). Is there a way to work around this without removing the connecting line by hand? I would appreciate any insight. Thanks!
You want the lines to show the formatting? Each line segment is associated with a marker, so if you select one marker, its line segment is the one that connects it to the previous marker. I don’t see how to set this up automatically in Excel, and even doing something with VBA sounds tricky.
Hi
I have two raws of data (one x and one y) for each point and I want input condition for both i mean if X>a number or Y>another number it shows me a color:
if x<=0 or y<=0 class one
0<x<0.2 or 0<y<0.2 class two
0.2<x<0,4 or 0.2<y<0.4 class three
0,4<x<0.6 or 0.4<y<0.6 class four
0.6<x<0.8 or 0.6<y<0.8 class five
0.8<x<1 or 0.8<y1 or y=>1 class seven
You can write formulas that refer to both X and Y, or to anything else you want.
Hi Jon, congrats for your blog, it’s really really useful.
I’ve a question about bar charts with a specific color based on value like bars in this link http://i.imgur.com/AzNkv.png.
Do you think is possible make a charts like the attached one for a low-skilled excel user?
How can I make the red-green bar?
Thanks a lot for you help
Cheers
Hi Jon,
Im having an issue with a data series i am trying to plot into a line chart. it plots all my points fine, but i need to see where there are gradient changes. i was wondering if there is any way to format the lines so that it is a positive gradient its green, negative red and unchanging as amber.
Thanks
Em
Emma -
Changing the format of the line segments cannot be done just with formulas, it requires VBA. An upcoming post will address this technique.
Hi Jon,
You have great instructions and examples for us to use. I hope you can help me on one step I am having trouble with. I tried to adjust the colored “blue” highlights of the “Conditional Formatted Bar Chart” from your instructions above where it says “We need to change the source data, removing column B and adding columns C:G. This is easily done by dragging and resizing the colored highlights.” For some reason I couldn’t change it so it highlights columns C:G. Please help.
Thank you!
Ken
Ken -
You can’t drag the colored highlight outlines? Can you change data by right-clicking and choosing Select Data? If it is a pivot chart, you can’t change its data.
Hi!
The instructions here has been a great help and I was able to conditional format the data points. I would like to know that if I want to give range in the formula -2<Y<=0, the excel is taking it as a NAME error.
What should I do now?
Please help as the instructions has beautifully helped me in making the plots for my datasets.
A NAME error means Excel thinks something in your formula is a Name, that is, a defined range or defined formula. Perhaps you’ve misspelled a function. What is formula in the cell with the error?
Hi Jon
This is a great blog. My query, is both for something more simple yet seemingly more difficult. I’m after showing via a equal segmented pie chart (almost grapefruit like) the status of a certain contract with say 8 points to it, each with a need to show a RAG rating on it:
Q1 = 2
Q2 = 1
Q3 = 1
Q4 = 3
etc with 1 = red 2 = amber 3 = green
I have been trying to frantiacally find an easy solution as to how to show this, can you help?
Thanks
Dan
You need to set up an algorithm that looks at the Qi rating to determine the format. For each segment in your chart, you need three possible values, for red, amber, and green (note that red and green are a poor choice for opposite extremes, given the prevalence of red-green colorblindness). So the data is like
Segment A1 =1 if red, =0 otherwise
Segment A2 =1 if amber, =0 otherwise
Segment A3 =1 if green, =0 otherwise
Segment B1 =1 if red, =0 otherwise
Segment B2 =1 if amber, =0 otherwise
Segment B3 =1 if green, =0 otherwise
Segment C1 =1 if red, =0 otherwise
etc.
First use values of 1 for all segments, so you can apply formats. Then apply the formulas. The appropriately colored segment appears (with value of 1) and the others do not (with zero values).
Smoke and mirrors.
Thank you!! This was great!
Thank you!! This was great! Really helped me out.
On a spreadsheet someone sent me, I notice at the bottom right of a section is a small arrow you can pull down or to the left to expand the section. I”ve created a new sheet with conditional formatting to shade every other line, but how do I get that little arrow feature?
Sounds like that formatted range is a Table. The formatting is Table formatting rather than conditional formatting.
Insert Table is next to Insert Pivot Take on the Insert tab. Of course, Convert to Table would be a better name, because you’re not really “inserting” anything.
Hi Jon,
Great site!
I’m able to resize the header, but when I try to resize the data set, it will not allow me to drag and select multiple columns.
I’ve tried right clicking the line graph > select data, but I get this error:
“The reference is not valid. References for titles, values, or sizes must be a single cell, row or column”
I’m using Excel 2010. Have I missed a step?
Thanks,
Joe
Joe -
I don’t know which data you’re trying to resize. If it’s the data for a series (you’ve selected a series and clicked Edit, or you’ve clicked Edit above the category labels), the range can only be one row or column wide.
Hi Jon, excellent site, thanks very much!
I am having one issue I woud be grateful if anyone had any ideas on. I have added data values to my chart but sometimes, when I change either a value or a threshold in the base data, the value on the chart changes to 0% and I have to manually recreate it. It seems to happen when the value shifts from one group to another.
Any ideas?
Many thanks,
David
How are you changing the value?
I am just typing over the number in the Y Values column – the relevant bar in the chart changes size and colour as expected but the data value changes to 0% as if it is still referencing the cell the value was in before (i.e. in columns C to G in your example).
Thanks, David
Also I am using Excel 2003, not sure if that is an issue…
By data value, you mean data label, right? You need to add data labels to all series, not just selected bars, and use a number format that suppresses zeros. Whatever your number format, append three semicolons (which will suppress negatives, zeros, and text labels). For example, if you’re using percentages:
0%;;;
That’s perfect, thank you!
Hey ! Thanks a lot for this simple and useful technique. Now I can make a control chart with automatic alerts.
Again, Thanks a lot, this is going to make me look very well with my boss :)
Dave Dudas (from Feb post) or anyone else – I am wondering if you would share your scatterplot example? That is exactly what I need and was searching for when I found this post. I’ll try working it myself of course, but would love some help.
Excellent stuff here everyone. Thanks for putting it out there. I’ll be sure to visit often now.
Hi, Jon. I’m trying to change the colour of the bubbles in a bubble chart but I don’t know how to do it. My idea is to use the colour as the “4th dimension”. X would be business attractiveness, Y relationship attractiveness, Z (size of the bubble) amount sold, and then the colour would be the profit, being green “High Profit”; Orange “Medium Profit” and Red “Low Profit”, I also want to keep the name of the client. So far, I have X, Y, Z (Bubble size) and name of the Client but I don’t know how to move on with the Profit “thing”.
I use Excel 2010.
Thanks a lot in advance!!
Juanjo -
As in the line chart example above, set up three different bubble series (three sets of Y values), one for each color.
Hi,
This was extreemly useful however I have a problem. The colur of my bars in the chart change with no problem however when the value drops below the threshold my data labels display 0 instead of the true value. I.e. colour changes from green to red at value of 5 but data label only displays true value if it is 5 or above. otherwise it displays 0 is there a solution to this?
Regards,
Neil
Neil -
Use a number format that suppresses display of zero. For example:
0;;;
0.0;;;
0%;;;
The first item in the semicolon-delimited list shows how positive numbers are displayed, the second (blank) shows negative, the third (also blank) shows zeros. So negative values and zeros are not displayed with one of these formats.
Jon,
Great article, we have peculiar problem. We are connecting to a cube (MS SSAS) to fetch data for a dashboard which is showing set of graphs (bar,line charts). We need to depict different colors based on data obtained from cube( we are making use of slicers, as dashboard needs to dynamic based on parameters selected). We have used VBA to depict the color changes in graphs, however VBA doesn’t work when used in Excel Services. We are using Excel 2010 and we have observed that in Excel 2010, Conditional formatting icon is disabled when connected to cube. We would appreciate if you could provide us pointers on the same.
Our problem statement is to change colors in Excel 2010 without using VBA for set of graphs (bar and line) which is fetching data from a cube. Pointers on this would really help, as we are struck.
Thanks
You could use formulas to set up different colored data points, per techniques in this article. However, the formulas have to be very smartly written to accommodate pivot tables with changing configurations.
Jon,
For some reason, when we access cube and show charts based on pivot data “conditional formatting” is getting disabled. Any inputs for the same.
Thanks 7 Regards,
Girish
Girish -
You mean Conditional Formatting in the worksheet? I can’t advise on this, because I don’t use cubes.
Hi John,
I need help in creating a bar graph with 4 columns of different data set and want to overlap all these 4 columns. I’ve successful with overlapping 2 columns but not with 3 or 4 columns. I need this chart for my report and will appreciate any help i can get.
Thankyou in advance for your help!
Maz
Maz -
You want bars in front to partially obscure the bars in back? I don’t know why you’re having trouble getting all the bars to do this, unless some are on the secondary axis. But obscuring data in this way may distort the impressions conveyed by the obscured bars.
I would like to be able to do something clever with the data points in a scatter plot: where the y-axis=Probability and the x-axis=$m. The data points represent the 80th percentile of a distribution for a number of variables.
I want to represent the statistical uncertainty of each of the underlying distribution fro each of the data points and I felt the following uncertainty criteria might apply:-
1. Magnitude of the data point represent by the colour of the marker – purple, blue, green, yellow,orange or red (low-high)
2.Uncertainty measured by Standard Deviation determining the diameter of the marker
3. Min-max range determining the thickness of the outer line.
4. The colour of the line to reflect the Upper Quartile – Lower Quartile range using the colours in (1) above.
Is there any way of achieving this attempt to describe the uncertainty around the data point.? Or some other solution to capture the uncertainty in the distribution?
Gavin -
A little formatting goes a long-long way, and you’re describing a lot of formatting.
1. What’s the magnitude of a data point? If it’s X or Y value, we’re already using position to denote that. Color’s not good to represent value, other than in broad categories.
2. Rather than diameter, which is a pain to do well, how about error bars? This also allows showing it in two directions, without having to try to scale an oval marker.
3,4. If it’s a range that can be represented on the chart, draw it on the chart, don’t abstract it even further into line weight or color. Maybe use dashed lines, or a lighter line, for some kind of limits.
Error bars are used in a lot of ways to try to capture uncertainty. Box plots show distribution in one direction. If you have lots of points, the density of a scatter cloud shows the distribution in the plane.
Hi
I have a table of values with X and Y number for each cell and I want to have a conditional fomatting for both x and y values.
You have two values (X and Y) in each cell?
To clarify this is a common method of displaying risks in a graph. Risk is calculated as the product of probability (Bernoulli distribution) and impact (a continuous distribution). The y-axis is probability 0 to 1, x-axis for impact 0 to 50. Obviously since the product of two distributions is a third continuous distribution and you cannot plot a number of risk distributions on a scatter plot. Companies are often interested in the 80th percentile so the scatter plot locates the marker of the basis of the P() v. P(80) impact.
This tells the reader nothing about the nature of the underlying distribution’s uncertainty in terms of standard deviation, min-max range, kurtosis, upper/lower quartile range.
This is the challenge to demonstrate the relative value of a set of risks by P(80) value and also their distribution uncertainty.
Yeah, “common method”. So you have to follow existing patterns while trying to include more information to help show the confidence in the plotted values. So some color coding is useful, and some bubble sizing also. Or maybe not.
Can you use your error bars to show the uncertainty in the position of your points, that is, to indicate where an 80% point would be if the probability ranges between 75 and 85%?
Here is an oddity I observed:
Marker size ranges from 2pts to 72pts
The outer line 0pt to 144pts
If you set the centre marker size to 72pts. Then start increasing the outer marker line.
As outer line increases in width the cenre marker starts decreasing in size although the format tool still shows 72pts.
When the outer line reaches 72pts width the centre marker starts to increase again until it reaches 72pts.
When the inner markets is fully back to 72pts the width of the outer circle is 144pts.
This is very odd, what is the cause of this?
Hi John,
There are no constraints or limitations on how I can do the graph. Anything that is an improvement is a step forward.
John,
This is exactly what I needed, and I wanted to reach out and say thanks for all your hard work! It’s very much appreciated, and I look forward to reading more of your blogs.
Cheers,
Bruce Williams (OE Specialist)
A big show gratitude you for your post.Much thanks again. Great.