Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-13-2018, 01:58 AM
JustAGuyTryingToPlot JustAGuyTryingToPlot is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2018
Posts: 2
JustAGuyTryingToPlot is on a distinguished road
Smile 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!
Reply With Quote
  #2  
Old 02-14-2018, 12:34 PM
p45cal p45cal is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 39
p45cal is on a distinguished road
Default

Supply a file with some sample data and the log-log chart you've done so far.
Reply With Quote
  #3  
Old 02-15-2018, 03:22 AM
JustAGuyTryingToPlot JustAGuyTryingToPlot is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2018
Posts: 2
JustAGuyTryingToPlot is on a distinguished road
Default

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
File Type: xlsx Band Plot.xlsx (101.8 KB, 4 views)
Reply With Quote
  #4  
Old 02-15-2018, 10:07 AM
p45cal p45cal is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 39
p45cal is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 02-15-2018, 03:37 PM
p45cal p45cal is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 39
p45cal is on a distinguished road
Default

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
File Type: png imageedit_1_5184116199.png (5.9 KB, 3 views)
Attached Files
File Type: xlsx msoforums38193Band Plot.xlsx (204.3 KB, 1 views)
Reply With Quote
Reply

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


All times are GMT -7. The time now is 06:43 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft