How can I create a contour plot like in the attached image? (preferably in Excel, but turn on other options)


Jay Iger

I need to create a graph that correctly represents the profit maximization model of the aircraft under different scenarios. I apologize in advance for my lack of understanding of the exact name. As mentioned, I've found the type of graph that best represents this situation, but can't figure out how to code/create it. I've tried using Excel and Think-Cell (either of them would work, but I just can't figure out how) with no luck. The following image is the ideal graph, the link is here:

!  [Outline Modeling]

Does anyone know how best to do this? Thanks in advance.

EDIT: The data I have now looks like this, the link is here:

enter image description here

Peter

You need to use the data to generate a Stacked Column chart.

Here is how I set up my own example data (before you posted your own data format):

enter image description here

Next, select all rows and only the first four columns of the data (42R x 5C) and Insert-->Charts-->2D Column-->Stacked Column. You should get a chart like this:

enter image description here

Then change the vertical axis options to show Bounds Min=1.0, Max=4.0, Units Major=0.2, Minor=0.1.

enter image description here

Next, select any of the data series in the chart and format the Series Options for Series Overlap=100%, Gap Width=0%.

enter image description here

After that, I deleted the Title and Legend, set the Line Style for both Axis to Solid Fill, Black Color. Then I changed the data series colors to be close to your example. Lastly, make sure the chart is selected (the border is highlighted with the squares at the corners), then Insert a TextBox over your data and type "B747-200P2F" and manually place it over the correct data area. Repeat this for the other series and you get this:

enter image description here

Finally, we'll work on the Jet Fuel price line. This series will be added to the chart, then plotted on the secondary axis and it's chart type changed to Line.

To start, select only the Jet Fuel price column (F1:F42) and then copy that range into the clipboard. Then, make sure the chart is selected and, from the Home ribbon, select Paste Special. Use the default settings, or choose Add cells as New Series, Values (Y) in Columns, check Series Names in First Row, uncheck Categories (X Labels) in First Column, then click OK. (Not much will seem different on the chart yet!)

The next steps are important to take in order (at least for me). Select only the "Jet Fuel Price" series and change the Series Options to Plot on Secondary Axis. Then change the axis options to set the range from 1.0 to 4.0 and set labels to None. Just so we're tracking, here's what I have so far:

enter image description here

The (almost) final step is to select only the "Jet Fuel Prices" series again, then right-click on it and select "Change Series Chart Type". Make sure to select the combo chart type, and make a selection for each series chart type, as shown in the following image:

enter image description here

Now (eventually!) just add another text box, put it in the label and set the text color to red.

enter image description here

Related


How can I create a color combination like an attached image?

Knicks 290192 I want to create background in Xcode like attached image. Any suggestions? swift boy The best way is to always use Image as background let navBackgroundImage:UIImage! = UIImage(named: "your_background_image_name_here") If you just want to set th

How can I create a layout like in the image?

icosahedron I want an image like this but when the texts are not of equal length the distance between the TextViews changes and when there are too many words go to the next line. The xml code for the layout I created is: <?xml version="1.0" encoding="utf-8"?>

How can I create a shape in android like the image I added?

Aksukumar Maldeh Can anyone tell me how to create a shape that is somewhat rectangular but ends up being a triangle. Jack' I would use the gradient image from the drawable folder. Let's call it background.png. You can also do it with the icons searchicon.png a

How can I create a shape in android like the image I added?

Aksukumar Maldeh Can anyone tell me how to create a shape that is somewhat rectangular but ends up being a triangle. Jack' I would use the gradient image from the drawable folder. Let's call it background.png. You can also do it with the icons searchicon.png a

How can I change the x-axis limits in the contour plot?

Kunal Singhal I want my plot to also show 7000 on the x-axis, since there are more than 6000 values in the data. I try to use, set_xlim(right = 7000)but an error pops up 'QuadContourSet' object has no attribute 'set_xlim' import numpy as np import matplotlib.p

How can I change the x-axis limits in the contour plot?

Kunal Singhal I want my plot to also show 7000 on the x-axis, since there are more than 6000 values in the data. I try to use, set_xlim(right = 7000)but an error pops up 'QuadContourSet' object has no attribute 'set_xlim' import numpy as np import matplotlib.p

Matlab: Create contour plot/image similar to SigmaPlot

Mosavi If a = columns, b = rowsand c = intensity. How can I create an image of dimensions aby bhaving an intensity for each pixel c: In SigmaPlot, to create images 29x4, a, band cthe format are as follows, how the data can be formatted in Matlab to achieve sim

Matlab: Create contour plot/image similar to SigmaPlot

Mosavi If a = columns, b = rowsand c = intensity. How can I create an image of dimensions aby bhaving an intensity for each pixel c: In SigmaPlot, to create images 29x4, a, band cthe format are as follows, how the data can be formatted in Matlab to achieve sim

How can i create a second image instead of filling like words

Kady I have the code below. I use this to use 1 image and use the "rel" and "title" tags to fill in the words to display with the actual image. This will create a banner-like system that uses text instead of all images. Right now, what I'm trying to do is popu

How can I create a plist like the image below?

Navier I am trying to create a plist with the following functionality. Inside the plist there are two keys 1.id 2.status The current value is id: 91 status: buy where the id should be unique. If I try to add a third entry like id:91 status:downlaod it should r

How can i create a second image instead of filling like words

Kady I have the code below. I use this to use 1 image and use the "rel" and "title" tags to fill in the words to display with the actual image. This will create a banner-like system that uses text instead of all images. Right now, what I'm trying to do is popu

How can I create a plist like the image below?

Navier I am trying to create a plist with the following functionality. Inside the plist there are two keys 1.id 2.status The current value is id: 91 status: buy where the id should be unique. If I try to add a third entry like id:91 status:downlaod it should r

How can i create a second image instead of filling like words

Kady I have the code below. I use this to use 1 image and use the "rel" and "title" tags to fill in the words to display with the actual image. This will create a banner-like system that uses text instead of all images. Right now, what I'm trying to do is popu

How can I turn the image in the correct orientation?

question_mark_77 I have a sheet of paper with scans of documents on it, I use tesseract to recognize the text, but sometimes the image is in the wrong orientation, then I cut these documents from the sheet and process each document individually, but I need to

I want to make border like attached image

username I want to make border like attached image in my app. Please help me as well. The original screen is the same as the code below. I am going to make the first screen image. tell me the changes in the xml. How can I make the border like a scary image? cu

I want to make border like attached image

username I want to make border like attached image in my app. Please help me as well. The original screen is the same as the code below. I am going to make the first screen image. tell me the changes in the xml. How can I make the border like a scary image? cu

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s

How can I remove the Altair yaxis of the attached image?

ZKK How to remove the blue part? import altair as alt from vega_datasets import data iris = data.iris() alt.Chart(iris).mark_point().encode( x='petalWidth', y='petalLength', color='species' ).configure_axis( grid=False ).configure_view( s