#1
|
|||
|
|||
Band (Stacked Area) Charts on Logarithmic Scales
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! |
#2
|
||||
|
||||
Supply a file with some sample data and the log-log chart you've done so far.
|
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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. |
#5
|
||||
|
||||
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. |
Tags |
charts |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
After updating linked excel charts in publisher, all charts are moved | effinglife | Publisher | 0 | 05-23-2017 02:27 AM |
Stacked Bar chart date issue | petermikula | Excel | 3 | 02-21-2017 05:55 PM |
Excel logarithmic scale acting up | kurite | Excel | 4 | 07-13-2016 12:17 AM |
Stacked Curve : What is the mathematical principle ? | othosama | Excel | 0 | 07-07-2014 06:54 AM |
How to edit cell data without changing print area. FIXED print area | VictoriaT8 | Excel | 3 | 02-22-2013 07:54 PM |