Hi Wizards of Excel,

I am trying to produce a band chart similar to this in Excel:
https://www.nachi.org/forum/attachme...7&d=1415330942

The first part was easy: I created a log-log plot with the upper and lower bands.

To fill the space between, I read several guides, including the following, before creating a separate spreadsheet with two linear bands overlapping each other
https://peltiertech.com/fill-under-b...n-excel-chart/

Unfortunately, the last part is where I come unstuck. I cannot seem to get a band chart with both the x and y axis using logarithmic scales. Is this supported by MS or is it even possible?



Thank you in advance!

Supply a file with some sample data and the log-log chart you've done so far.

Thank you for you help with this!

I have attached a workbook with two worksheets:
1. A band chart (using stacked areas) to show the error margin about a nominal curve
2. A log chart with the error bands and the columns for a stacked area plot ready to go.

Hopefully you can find something that I am missing

Attached Files

Band Plot.xlsx (101.8 KB, 14 views)

Peltier's technique uses the fact that we can have a date in the category axis (x-axis) of an area chart and Excel will plot them, even if they're not equidistant, like an x-y chart. He usees a secondary horizontal axis to plot hese on.
I've had a play with this and come up against a barrier when I try to convert a non-logarithmic date scale to a logarithmic one - can't.

All I can suggest at the moment is instead of plottting the raw x values, plot the log of the x values (calculated on the sheeet) and their corresponding date equivalents on non-logarithmic scales, You'll only have to do this for the x-axis values.

This messes up the x axis labels, which you could mask by overlaying a picture of the scale from a logarithmic plot!

I'll be working, on and off, trying to produce proof-of-concept charts, initially using Jon's example data and secondly on your data , so I can't give you a guess as to when I'll have done this, so I posted in the interim since you might be able to do it yourself in the meantime.

In the atttached I have this:
Capture3.GIF
It's what I suggested in the previous message, but instead of just the axis labels, I took a picture of the vertical gridlines and x-axis labels, made the white transparent, brought it back into Excel and superimposed it on the chart at cell N31 of the Log Chart sheet. I attach that image too.

Quite a faff.

Attached Images

imageedit_1_5184116199.png (5.9 KB, 19 views)

Attached Files

msoforums38193Band Plot.xlsx (204.3 KB, 14 views)