Control Chart Shape Colors By Values?
May 27, 2007
Is there a way to make the colours in a chart (pie, column etc) correspond to a value? I'm using Excel 2002, soon to start using 2003.
For example, imagine a normal pie chart showing the population of each country in North, Central and South America. But for each country, colour gradations would be used to show levels of wealth (e.g., GDP per capita) as follows:
saturated red = bottom 20% (poorest)
pink = 21-40th percentile,
white = 41-60%,
gray = 61-80%,
black = 81-100% (richest)
Is this possible? And not to get too greedy, but can you use even finer gradations -- say, with ten categories, as opposed to the five in the example above?
View 9 Replies
ADVERTISEMENT
Jul 15, 2014
Is there any way to place a Control Tip for a shape on a excel worksheet?
View 3 Replies
View Related
Aug 5, 2014
I'm working with a pie chart that has a dynamic range as its data source and a dynamic range as its legend. The chart shows ratios of bought items depending on customer type. So, when you switch from a "Hair" customer to a "Bath & Body" customer, the ratios shift and the legend changes as well (i.e. "Hair - 25%" to "Hair - 10%").
Is there a way to fix the colors permanently so that as the ranges change, the colors remains the same for each category?
I've seen some VBA for it, but it was for data in long columns, whereas my data is in one range in the middle of the worksheet.
I can attach the file if it makes things easier.
View 1 Replies
View Related
Jun 9, 2006
How to adjust the shape of the chart in the worksheet? I try to write the code, but can not work.
ActiveChart.Shapes.ScaleWidth 0.87, msoFalse, msoScaleFromBottomRight
ActiveChart.Shapes.ScaleHeight 1.5, msoFalse, msoScaleFromBottomRight
View 3 Replies
View Related
Dec 9, 2013
I have a line charts with values above and below zero.
Im looking for a way to colour the steps below zero in one colour, and above zero in another colour - without doing it manually.
Using Excel 2007.
View 1 Replies
View Related
Apr 19, 2014
I am wanting the colors of the bars in a stacked chart to change based on the date in the X Axis. As the current date arrives, the stacked bar needs to change to various blue shades. If the date is in the future, the stacked bar needs to be various grey shades.
View 2 Replies
View Related
May 5, 2008
I have to create a chart XY Scatter plot in excel. I have to differentiate the data points color based on the another column "category". Now I can change the data points color manually. Since the number of points is huge, is it possible to color the data points based on a column?
View 5 Replies
View Related
Mar 20, 2014
I am working on a project where I am virtually almost finished except for a minor change with the pie chart. I am analyzing some data and recorded a macro to do this and also the pie chart for visualization. However, I do not like the color of the default pie chart colors and would like to customize it. How could I change this within the macro I have recorded?
[Code] .....
View 4 Replies
View Related
Jul 7, 2013
My pallet lost color-coding - if I hover over each little scare it displays the names for the colors and if I click on them they color the cells with the right colors, but the palette itself lost the visual display of colors except for 8 colors: black, blue, red, magenta, yellow, cyan, and white.
I use color-coding of cells a lot and I find it difficult to work without visual clues. At least the hover-support allows me to get the work done, but with difficulty.
View 12 Replies
View Related
Sep 17, 2013
I have rows that contain property identifiers and their owners. One property ID can have multiple owners. I would like to color the rows differently to show each unique property ID with their 1 or more property owners. I have attached a file showing what I would like (with fake data). In excel, I was able to figure out how to highlight the duplicate values, but it only does them in one color. I would like each property ID value to have it's own color - as I show in the attached file. In the file, I have value 1234 as one color, the 4546 values as another color and 2233 values as another.
View 3 Replies
View Related
Feb 6, 2014
(I am using different data IRL which is company sensitive so I have designed a simple example spreadsheet.)
Ok, So I have a list of words A2:A4 and I have created a Control Box which allows me to select which word I want from the list.
On a separate tab I have lists of data which relates to individual words from the A2:A4 list.
What I what to achieve is when the word is selected from the drop down menu it will create a Pie chart showing me the break down of percentages and attributing 'companies'.
View 6 Replies
View Related
Feb 7, 2014
I've used trend lines to find the mean and average but for some reason I have not been able to set an upper and lower limit. without introducing a new column.
View 6 Replies
View Related
May 12, 2006
I am trying to use the Chartspace object on a VBA form in Excel 2002, but am unable to find out how to specify the speadsheet data to be used for each series. I have found out how to add series, and to add titles & legend etc.
View 5 Replies
View Related
Aug 31, 2007
I have a feeling this is a stupid question, but I can't figure it out right now...
I have a worksheet with a bunch of charts as worksheets. I want to put command buttons on these charts. Whenever I select a tab which as a chart on it, my controls are grayed out, and I cannot insert a button. When I select a tab of a regular worksheet, I can insert buttons to my heart's content. Why can I not insert controls to the tabs which are charts? The ridiculous thing is, I have done it before. When I open that file, my buttons are on the chart. However, even in that sheet, I cannot insert more. Do I have a setting that I have changed, or somewhere I can look to enable the ability to put controls on a chart?
View 4 Replies
View Related
Jul 13, 2014
When I hide columns in a column chart the different fill colors I used on specific columns no longer show up with the colors I originally had. Is there a way to maintain the proper sequence of column fill colors even when some columns are hidden?
View 1 Replies
View Related
Jul 25, 2013
I was wondering if it would be possible to filter by two consecutive cell values or colors. For example if I have in "A"
X1 (red fill)
X2 (blue fill)
X1 (red fill)
X3 (xx fill)
X3 (xx fill)
X1 (red fill)
X2 (blue fill)
X4 (aa fill)
I want to be able to filter so that the consecutive cells for x1 and x2 show up or red followed by blue.
So when I filter it will only show rows 1 & 2 and 6 & 7.
X1
X2
and there would be many of these values in the spreadsheet.
View 10 Replies
View Related
Jun 19, 2009
I know this can be done, as I have seen it before, but can't seem to figure out how to replicate it.
I have a speadsheet in which I have a drop-down box for a certain column's values. How do I automatically have each independent row's background color change dependant upon the value selected in that row's drop-down cell box (and update color automatically if a different drop-down selection is made later)?
For example:
Row 1: Cell C Drop-Down Value = "Yes"...change row color to GREEN
Row 2: Cell C Drop-Down Value = "No"...change row color to RED
Row 3: Cell C Drop-Down Value = "Maybe"...change row color to YELLOW
View 9 Replies
View Related
Jan 30, 2014
Trying to create a dynamic chart herewith control in combo box.
Chart 2.xlsx
View 3 Replies
View Related
Mar 15, 2014
I have a couple of hundred string values in column A. I am trying to create the same number of rectangle shapes in column B, each one taking its name from the corresponding cell in column A. I keep hitting the dreaded 400 error code .
Attached File : test add shapes.xlsm
View 3 Replies
View Related
Jan 1, 2007
i am trying to enter the EndX coordinates (The third number: 500) by entering a number in a forms textbox
ActiveSheet.Shapes.AddLine(0, 100, 500, 100).Select
how can i break the code up to enter the coordinates via textbox's
View 6 Replies
View Related
Nov 30, 2007
I am trying to convert some text from a number of cells to shape in another workbook. The problem is, if the text in one of the cells is too long (from testing it by too long i pretty much mean roughly 100 characters) then it doesn't pass anything at all to the shape. Is there a way around this so that all text will be converted to the shape regardless of its size?
By the way, the code is:
ActiveWorkbook. Sheets("Sheet1").Activate
ActiveSheet.Shapes("Text Box 1").TextFrame.Characters.Text = "1. " & Priority1Range.Value & Chr(10) & "2. " & Priority2Range.Value _
& Chr(10) & "3. " & Priority3Range.Value & Chr(10) & "4. " & Priority4Range.Value & Chr(10) & "5. " & _
Priority5Range.Value
The variables 'Priority1Range' represent the cell the text is in that I am trying to pass and it's variable type is Range. I have tried declaring the Priority1Range.Value as a string variable and using this instead but this doesn't work.
View 9 Replies
View Related
Apr 13, 2014
All of the functions' X Axis were given the same data (12,24,36,48), except ROULETTE and TOURNAMENT which were also given (60) for the X axis.
Why do the NORMAL bars aren't located on the place they should on the X axis?
For example, the 1st bar (from the left), should be a little more to the right. The others should move to the left.
View 1 Replies
View Related
Jan 18, 2009
I am using the VBA Chart Control and I have the following instruction;
Me.ChartSpace1.Axes(ChartAxisPositionEnum.chAxisPositionCategory).Numb erFormat = "mm/dd/yy"
The chart is a "chChartTypeLine". the problem is that i cannot change the format of the X-Axis to a Date (mm/dd/yy) format no matter what I try? I keeps wanting to keep it as "General", here is the code;
Private Sub CommandButton1_Click()
Dim ser As ChSeries
Dim cht As ChChart
Dim MinValue As Double
Dim MaxValue As Double
MinValue = Sheet1.Range("D2").Value + 10
MaxValue = Sheet1.Range("A2").Value
View 9 Replies
View Related
Sep 21, 2006
I made a pivot chart. On the X axis are days of the year. I would like the axis to give the months rather than the days, because it is easier to read. But when I select the chart's axis, I don't have acces to any "number" sheet in the "Axis format" section. I could just change the scale.
ActiveChart.Axes(xlCategory).Select
With Selection.TickLabels
.Alignment = xlCenter
. Offset = 100
.ReadingOrder = xlContext
.Orientation = 45
.NumberFormat = "[$-41D]mmmm;@" 'I added this line
End With
ActiveChart.HasPivotFields = False
View 3 Replies
View Related
Jan 14, 2013
Scatter chart on excel 2010
My X axis range is small 1 to 4. but I want to show minor grid lines at 0.5, 1.5, 2.5, and 3.5 only. I do not want lines at 1, 2, 3 or 4. I am not sure how to achieve this. as switching on minor grid lines, included those at the integers as well as at the half way points.
View 1 Replies
View Related
Sep 1, 2007
I want to add a control under Chart on the menu bar. This line of code errors with "Invalid Procedure Call or Argument"
With Application. CommandBars("Worksheet menu bar").Controls("Chart")
Change "Chart" to "File" or "Edit" or "Tools" and it's fine.
The Chart item only appears when a chart is selected, but it errors even when a chart on the worksheet is selected.
View 7 Replies
View Related
Mar 4, 2009
when i run the below code i get an error 438 'object doesnt support this property or method'
View 2 Replies
View Related
Apr 18, 2013
How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.
View 1 Replies
View Related
Dec 17, 2013
I have created a pie chart showing top 10 best selling categories. However, on this pie chart, I want %age of overall sales to be shown.
At the moment say I put in the following
Catalogue 1 100
Catalogue 2 98
Catalogue 3 92
Catalogue 4 85
Catalogue 5 84
Catalogue 6 75
[Code]....
I add Data Labels and select the percentages. This shows at Cat 1 having 12.5% of the sales (100 of 800 sales), Cat 2 having 12.25%, and so on..... However, what you don't see is the following data:
Catalogue 11 60
Catalogue 12 58
Catalogue 13 57
Catalogue 14 57
Catalogue 15 56
So based on 1,088 sales, Cat 1 at 100 is actually only 9.19% of TOTAL sales.
I understand what is happening, the chart is giving the percentage based on the data inputted into the chart.
I did consider adding an 11th category to the chart, which was the total of Catalogues 11-15. Whilst this does give a more accurate percentage figure (as now all sales have been inputted), it makes the chart look ****
Is there a way of either adding the 11th category, and then "hiding" it, so that the chart doesn't display it, but uses it's value to calculate Catalogues 1-10s percentage?
BTW: The reason I ask is that I could be dealing with anywhere from 30 to over 100 catalogues. So it's not ideal showing the others in 1 chart.
View 1 Replies
View Related
Sep 1, 2006
i have made a simple userform in which there are 3 combo boxes. a user chooses options from these boxes and then these options are put into 3 cells in a worksheet. what i need to do is create a macro or vba code so that the contents of these 3 cells are used as the Criteria for the autofilter.
View 4 Replies
View Related