Charts
in [Excel]
|
Chart background colors by value I would like to shade the background of my chart based on a value selection, ie. values falling in a range of 4-29 shaded in yellow, 30-45 blue, etc. ... 22 Apr 2010 15:34
Shape Range Below is a subroutine that passes in 2 variables. I am concerned with the word "Selection" used for ShapeRange and would prefer to eliminate it. All my attemptes have resulted in errors. I want qualify the code to prevent error. Is selection a keyword for ShapeRange or is there a way to qualify it? Thanks i... 22 Apr 2010 12:26
Offset Horizontal axis data Excel 2007 My horizontal axis is made up of the week number values for the year week 1 to week 53. I have two sets of data to plot as bars against thos axis. The first set is data from 2009 and the second set is the data collected so far from 2010. My problem is that the 2009 data started being collecte... 22 Apr 2010 13:29
Calclulating percentages Hi I am creating a bat chart which will show a total score of e.g. 77%. I need to know how to work out how to show the part 6 components play towards this 77%. The six components are 83, 96, 84, 49, 35 and 64. How can I calulate this to show on chart please? ... 23 Apr 2010 02:25
how to display multiple charts on a single chart sheet hello, I know there is a way to display multiple charts on a single chart sheet i just can't figure out how can i please get a little guidance to complete the data report that i am putting together. RIght now I have two charts each in one single chart sheet. I've tried copy and paste and moving the chart loca... 21 Apr 2010 02:14
Issue with linked text box formatting Linked text box does not hold format of cell that you are linking to in Excel 2007 whereas they did in Excel 2003, is there any way around this? Example 1. Create Data on Sheet1 from A1 A 1 B 2 C 3 2. Format Sheet1!$A$1so the t... 20 Apr 2010 16:32
Add text box via the keyboard only Is there any way in 2007 to add a text box onto a chart sheet without using the mouse? In 2003 you used to just be able to type into the formula bar and hit enter. In 2007 I have typed using the keyboard navigation Alt>N>X but then you need to use your mouse to draw the box, any suggestions? ... 23 Apr 2010 02:25
Adding a text box to a chart sheet via the keyboard only Is there any way in 2007 to add a text box onto a chart sheet without using the mouse? In 2003 you used to just be able to type into the formula bar and hit enter. In 2007 I have typed using the keyboard navigation Alt>N>X but then you need to use your mouse to draw the box, any suggestions? ... 20 Apr 2010 16:32 |