i have a graph, actually it is an aircraft weight and balance chart. It has an odd shaped envelope. How do I create a warning if a plot falls outside this area? If the area was square it would be easy with =IF(and(j234000),"warning","ok")) etc etc. but what if the area is an odd shape where on one side x increase and y decreases, on the other it is the other way.
Any ideas? so basically I want to create a warning flag when the plot falls outside the designated area.
Am I getting too complicated here?
Thank you
I'm trying to paste an image as a background to a radar chart. The objective is to let the user choose from a number of background images to suit what is being shown on the radar chart.
I've tried recording a macro but it skips the vital step of pasting the image from the clipboard. (This isn't how I'll actually use the code but I've left the macro as recorded for completeness).
Code:
ActiveSheet.Shapes.Range(Array("Picture 21")).Select
Selection.Copy
ActiveSheet.Previous.Select
ActiveSheet.ChartObjects("Radar").Activate
ActiveChart.PlotArea.Select
'this is where the formatting happens but the macro hasn't recorded it
Can anybody help fill the gap?
An alternative would be to have a stack of images behind a transparent chart that get made visible as required. Code for making sure they line up exactly with the plot area would be my difficulty there though.
I'm playing around with code to generate charts.
How can I let the code fill the entire chart area with the plot area?
I can use:
PlotArea.Left = 1
PlotArea.Top = 1
To position it in the leftmost corner, but I have yet to find a way to automatically fill the entire area.
Any ideas?
Hi,
I am trying to create a dashboard report where I will have several pie charts embedded into a worksheet. I am creating the charts and then pasting them into the destination worksheet and resizing them by holding down the alt key so that they will snap to the grid. However, I accidentally dragged the plot area out to match the chart area and now I cannot make the plot area smaller again. I need to make the actual pie chart smaller so my chart labels won't look too crowded. I don't need code to do this. I haven't charted much in 2007 but did a fair amount of charting in 2003 years ago. Things have changed in 2007......
Thanks,
Joe
Everyone,
I have a chart that is doing something weird. This is an area chart with a double axis. Most of the data is in the 200-400 range. However, there is one higher bar on the Y2 axis that goes above the maximum Y of the plot (this is deliberate). Now, this has always worked in the past. However, now, all the lines charted on the Y2 axis of are showing outside the plot area (it's actually graphing the data on top my title up to the top of the chart). The Y1 axis works fine, it's just the Y2 axis that is doing this.
What property do I need to set to get it to stop?
Sizing handle does not work. Format series data options does not have option
of "size of second plot" box, only degrees and color.
I'm using Excel 2007. I need the plot area transparent but I can only make it so if the entire chart area is transparent. Is this a limitation in Excel or am I just proving myself stupid again?
Good Afternoon,
I am creating a progress chart in an excel dashboard which shows current progress of a project and whether or not it is in front of or behind schedule.
My table is as follows
A B C D
Project name Target Completion Current Completion Today
Date
I have a number of projects each with a name, a taret completion date (an integer representing a month), a current completion date (an integer representing a month) and todays date (an integer as a month, using the
Code:
=month(today())
command) which remains constant for all projects
Currently I have a blue bar representing column B, and a green bar representing current progress. I have formatted the "todays date" series so it is invisible and added a trendline which appears as a vertical red line down all of the graph.
What I want to do is shade the plot area from the left of the graph up to this point to represent the time that has passed from the start of the year to today.
I think this
HTML Code:
http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html
is close
Any suggestions?
I have three sets of data in the attached spreadsheet. One X (Current Offering), one Y (Strategy), and then a third (Market Presence) that I don't know what to do with as it determines how big the plotted X,Y plot points are.
I essentially would like to replicate the attached jpg. Not sure how to combine the area chart (the radial circular lines) with the other data either. I don't have that data in the sample.xlsx though. I guess I would have to make it up to form the 4 areas to the chart.
I understand that in order to also display the labels for the data I need to do it through XY Chart Labeler
http://www.appspro.com/Utilities/ChartLabeler.htm
I've downloaded it, but haven't tried it yet, but I'm sure I can figure it out. There's several posts here on how to do it.
I'm in Excel 2007.
The plot area default color for excel charts is grey. How do I permanently
make it white?
