Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Advanced color chart
I have some range data based on speed and altitude of a projectile. I would
like to make a singe 2D chart with speed and altitude along the x and y axes. The range data would then be plotted in different colors/shades. For instance, the darker the shade, the larger the range. And obviously, the legend would have to include a color pallete indicating what ranges go with what colors. For points with no data, the colors would be interpolated between existing points. Another real-world example of this type of plot would be a temperature based weather map where the x and y axes are latitude/longitude and temperature is shown in different colors/shades. Is this possible in Excel? I think that this type of chart would be easy to read and would also illustrate a lot of information. |
#2
|
|||
|
|||
If you don't need fancy, Excel can handle this. You need to arrange data like this:
X1 X2 X3 X4 X5 Y1 Z11 Z12 Z13 Z14 Z15 Y2 Z21 Z22 Z23 Z24 Z25 Y3 Z31 Z32 Z33 Z34 Z35 etc. You need regular arrays of X and Y values, and one Z for each X-Y pair. Leave the top left cell of the matrix blank. Make a contour or surface chart. You can adjust the colors by double clicking on the legend. I've written an article on Surface and Contour charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=447 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bsh152s wrote: I have some range data based on speed and altitude of a projectile. I would like to make a singe 2D chart with speed and altitude along the x and y axes. The range data would then be plotted in different colors/shades. For instance, the darker the shade, the larger the range. And obviously, the legend would have to include a color pallete indicating what ranges go with what colors. For points with no data, the colors would be interpolated between existing points. Another real-world example of this type of plot would be a temperature based weather map where the x and y axes are latitude/longitude and temperature is shown in different colors/shades. Is this possible in Excel? I think that this type of chart would be easy to read and would also illustrate a lot of information. |
#3
|
|||
|
|||
I actually already figured it out by finding your article through google.
Helped a lot. Now, I've got another problem. In my data, I have a lot more Y variables (80) than X variables (7). When I make the plot, it looks long and skinny and I can't stretch it out. It always keeps the spacing between x ticks and between y ticks the same. So basically, I can't change the aspect ratio. Is this something you can't do? "Jon Peltier" wrote: If you don't need fancy, Excel can handle this. You need to arrange data like this: X1 X2 X3 X4 X5 Y1 Z11 Z12 Z13 Z14 Z15 Y2 Z21 Z22 Z23 Z24 Z25 Y3 Z31 Z32 Z33 Z34 Z35 etc. You need regular arrays of X and Y values, and one Z for each X-Y pair. Leave the top left cell of the matrix blank. Make a contour or surface chart. You can adjust the colors by double clicking on the legend. I've written an article on Surface and Contour charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=447 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bsh152s wrote: I have some range data based on speed and altitude of a projectile. I would like to make a singe 2D chart with speed and altitude along the x and y axes. The range data would then be plotted in different colors/shades. For instance, the darker the shade, the larger the range. And obviously, the legend would have to include a color pallete indicating what ranges go with what colors. For points with no data, the colors would be interpolated between existing points. Another real-world example of this type of plot would be a temperature based weather map where the x and y axes are latitude/longitude and temperature is shown in different colors/shades. Is this possible in Excel? I think that this type of chart would be easy to read and would also illustrate a lot of information. |
#4
|
|||
|
|||
You're stuck with that aspect ratio. If you don't mind a klunky workaround, here's
what I might do: Insert ten (or another suitable amount) empty columns between every pair of adjacent X columns, and use simple formulas to interpolate values for the in-between cells. When you make this plot it will be much closer to square, or at least to a rectangle you can live with. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bsh152s wrote: I actually already figured it out by finding your article through google. Helped a lot. Now, I've got another problem. In my data, I have a lot more Y variables (80) than X variables (7). When I make the plot, it looks long and skinny and I can't stretch it out. It always keeps the spacing between x ticks and between y ticks the same. So basically, I can't change the aspect ratio. Is this something you can't do? "Jon Peltier" wrote: If you don't need fancy, Excel can handle this. You need to arrange data like this: X1 X2 X3 X4 X5 Y1 Z11 Z12 Z13 Z14 Z15 Y2 Z21 Z22 Z23 Z24 Z25 Y3 Z31 Z32 Z33 Z34 Z35 etc. You need regular arrays of X and Y values, and one Z for each X-Y pair. Leave the top left cell of the matrix blank. Make a contour or surface chart. You can adjust the colors by double clicking on the legend. I've written an article on Surface and Contour charts: http://pubs.logicalexpressions.com/P...cle.asp?ID=447 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bsh152s wrote: I have some range data based on speed and altitude of a projectile. I would like to make a singe 2D chart with speed and altitude along the x and y axes. The range data would then be plotted in different colors/shades. For instance, the darker the shade, the larger the range. And obviously, the legend would have to include a color pallete indicating what ranges go with what colors. For points with no data, the colors would be interpolated between existing points. Another real-world example of this type of plot would be a temperature based weather map where the x and y axes are latitude/longitude and temperature is shown in different colors/shades. Is this possible in Excel? I think that this type of chart would be easy to read and would also illustrate a lot of information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|