Excel VBA - Change Marker Styles For All Series Excluding Unmarked Lines

Aug 4, 2014

I have a macro that changes the marker style for all series in a scatter chart, chosen through an input box.

[Code].....

It works nicely, but I want it to exclude any series that do not have markers (i.e. lines used to indicate a reference value). I've tried an if-then statement after the With statement, but it will add markers to any line series:

[Code] ......

Basically, if the series has markers or line+markers, I want it to change the marker style, otherwise do nothing with the series.

View 5 Replies


ADVERTISEMENT

Changing Marker Size In Charts For All Series At The Same Time?

Apr 24, 2014

I have a chart with 5 different series. Instead of editing each one, say the marker size, is there anyway I can change the marker size for all of the different series at the same time?

View 1 Replies View Related

Change Custom Cell Styles

Oct 1, 2009

I have a workbook in Excel 2007 with several sheets imported from other workbooks. In the course of this, one of them has brought several custom cell styles with it and I would like to be rid of them, as they clutter up the cell styles gallery.

Most of them were cooperative and deleted simply enough by right-clicking and selecting 'Delete', but one is proving a little more stubborn.

When I mouse over it, it plays the 'alert' noise (the 'bink' you get when Excel wants to alert you to something) and then nothing happens. There is no noticeable change to text or cell, as there should be thanks to 2007's previewing ability. Trying to apply the style results in the message

"Style '
386grabber=VGA.3GR
' not found."

(the line breaks are present in the message and seem to be because the style name actually has character returns as the first and last characters).

Is there a way to delete this style, or am I going to have to resign myself to having an annoying noise every time I try to apply styles

View 9 Replies View Related

Graphing - Macro Won't Change Marker Fill Colour

Jan 14, 2014

I'm recording a macro, so a line in my graph is a specific green. The marker fill won't retain the green, it always ends up blue. the lines and marker line is green. no matter what color I try the marker fill will always be blue. How to correct this?

View 6 Replies View Related

Excel 2010 :: Change Style For Certain Number Of Lines In Word Doc From VBA

Apr 29, 2014

i have done in Word VBA successfully (basically, change the Style for a certain number of lines):

VB:
Dim myRange As Range
Set myRange = ActiveDocument.Range(ActiveDocument.Range.Start, ActiveDocument.Range.Start)

[Code].....

View 2 Replies View Related

Excel 2010 :: Cell Styles Not Deleting

Apr 15, 2014

I have some cell styles that refuse to be deleted in Excel 2010. I can see them on the ribbon, but right clicking and deleting doesn't do anything. Any way I can get rid of them? Just makes things look very messy. If I click them it says "Style 'XXX' not found."

View 3 Replies View Related

Excel 2007 :: Deleting All Cell Styles?

Sep 15, 2010

I have a list of Cell Styles under the Styles tab in Excel 2007. I want to delete all the Cell Styles since its slowing down opening and operating of the Excel file. I do not want to individually delete them by right click-delete. Cmarco to run for performing this action?

***I DO NOT WANT TO REMOVE CELL STYLES FROM A RANGE- I WANT DELETE THE CELL STYLES FORM THE STYLES TAB IN THE HOME RIBBON IN EXCEL 2007****

View 1 Replies View Related

Prevent Excel From Applying Table Styles?

Dec 1, 2011

Is there a way of preventing Exel from Applying table styles, when converting a range to a table. and leave the formatting of the table intact?

View 1 Replies View Related

Excel 2003 :: Border Line Styles Not Working

May 20, 2012

(Excel 2003, using Format/Cells)

I have selected a range of multiple rows and columns. I can change the alignment, cell color, where border lines appear, and the color of border lines.

However, I can not change the border line style. No matter what style I select, when drawn on the sheet it apppear as a thin solid line. I've tried all the dashed/dotted line options, but they appear to have no effect.

Ultimately, I want to color alternating rows of cells, and (since coloring hides grid lines) I want to add border lines the same color and style as the hidden grid lines.

View 2 Replies View Related

Excel 2010 :: Creating A Simple Line Marker Graph?

Mar 2, 2014

I'd like to create a simple graph exactly like the one on the picture, but for the life of mehow to do this on Excel 2010.This is the data I have:

Seperation First target Second target
0 59.00% 0.00%
2 64.28% 40.62%
4 62.68% 48.99%
6 60.81% 65.83%
8 61.82% 70.21%

View 6 Replies View Related

Select Series (lines) In Line Graph By Adding Userform With Checkboxes On A Chart

Apr 15, 2014

I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?

View 2 Replies View Related

Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart

Nov 27, 2011

I am looking for a creative way to display a pie chart within a data point marker of a line chart.

My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)

I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.

I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.

The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)

the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.

I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.

View 1 Replies View Related

Change Format Of Many Lines

Sep 8, 2009

I need to turn millions (I'm guessing around 4-5 million, though I'm not completely sure since I don't have a program that can actually open the file completely since it's so large) of lines of text which are formatted like this:


05/15/09 09:45:01 AM 16600 1

into lines which are formatted like this:


20090515 094501;16600;1

I could do it by hand, but since there are literally millions of lines like this, it would probably take me about a year to do. So my questions are:

1. Is there a way to do this relatively quickly in Excel?

2. When I open this file in Excel, the year and time tabs aren't filled in with the year and time, but simply with "#######", though if I click on the cell, the year or time is displayed up in the "fx" function bar thing. Is there a way to keep these cells from displaying as "#######"?

3. Right now when I open the file (it's a CSV file), it only opens a little over 1 million of the lines, and an alert pops up that says the entire file was not opened. Is there any way to get the entire file to open? If not, how could I split the file into pieces that are small enough for Excel, and then how could I join those pieces back together?

View 11 Replies View Related

Change A Series Of Rows.

Feb 12, 2009

I want to change the values arranged in the row wise to the format I have attached in the excel sheet. Manually it would be very tiresome.

View 4 Replies View Related

Change Colour Of Chart Series

Jan 4, 2010

I'm attempting to write a code that will change the colour of a series in a chart based on the name of each series. i.e. I have Roads, Water and Rail as three of my series names. can i somehow assign the colours yellow, blue and red to these series using macro code.

View 5 Replies View Related

Stacked Area Chart Series Colour Change

Jan 6, 2010

I have a stacked area chart located on its own individual worksheet. I would like to use VBA to apply colours to individual series based on the name of that series. I have applied the following code which I found on the following help forum, changing it slightly to fit my needs: http://www.ozgrid.com/forum/showthread.php?t=91381

View 3 Replies View Related

Change Color Of Chart Series Based On Source Value

Apr 23, 2008

it is possible to have the series of a stacked graph to change color based on the source value.

e.g.
i have a stacked cone graph made up of 5 piece (series)
i need each piece colored either green, yellow or red depending on whether its value is large than another

View 5 Replies View Related

Date Function In Excel Excluding Weekend And Holidays

May 31, 2013

If I am using today's date, example: 5/30. I am looking to populate the next 10 business days.

Example: 5/31, 6/3. 6/4 etc.

I want to exclude weekends and holidays. I believe the following formual works to exclude weekends, but not sure how to incorporate holidays in the mix. =workday(today(),1) for one day after today, and then just keep increasing the number for days out.

View 2 Replies View Related

Changing Between Two Custom Styles?

Mar 27, 2013

I am trying to get a phone number column to change between two custom styles. I have added the styles in as:

Mobile: 0000 000 000
Extenstion: x00000

I need column E5 down to change between the two if < 6 or >5 numbers are used in a cell to change to the correct style.

Does this can be done just using the styles or vba coding is required.

I already have some vba to add the date into column B if column A is altered.

View 2 Replies View Related

Conditional Formatting Using Styles

Oct 31, 2006

I know OpenOffice can do it but I can't seem to figure out if Excel can or not. I have various styles defined to include the font, color, pattern, etc. which are setup the way that I want. I also have Options>View - Zero Values.", "style="background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;"");' onmouseout='GAL_hidepopup();'>formatting.htm" target="_blank">conditional formatting formulas set where I want. All appears to be working well. What I want is that the result of the conditional format uses the style reference rather than the absolute reference by changing the format in the conditional dialogue box. Can Excel handle that? If so, how?

View 3 Replies View Related

Different Styles Of Command Buttons

Aug 23, 2007

I was creating command buttons and had trouble using the linked cell. I found an example on the forum here but the command buttons seem to have many different behaviors. On the attachment, "Button 1" and "Button 2" are the ones I created in Excel 2003. "Button A" and "Button B" are from an example I found on the forum.

1 and 2 can only be edited on design mode, and have the formula "=EMBED("Forms.OptionButton.1","")" by default (which yields an error when exiting the formula field). A and B can be edited at any time, and have an extra tab ("Control") on the Control Format dialog. This seems to allow the linked cell to be set and function pretty handily. Are A and B from a different version of Excel? Auto Merged Post;Here's the attachment:

View 3 Replies View Related

Change Chart Data Series (rows) Using Named Ranges?

Mar 13, 2013

I have a chart in a workbook that works fine by looking at the following data series:

=Workings!$A$2:$C$35

In the data series above...where the numbers are 2 and 35 I have named ranges "CHART_Start_Row" and "CHART_End_Row" which will change dynamically as appropriate and can replace these static numbers - but how do I incorporate these named ranges into the data series reference?

View 2 Replies View Related

Change Order For Chart Series Collection Macro Code

Mar 18, 2008

I have a bar graph with 2 series of data. Anyone knows how I can specify the order in which they appear? code looks similar to the following. The bar graph shows the second series before the first series. How do I reverse the order?

With cht
.ChartType = xlColumnClustered

' first data series
Set ser = .SeriesCollection.NewSeries
With ser
.Values = someValues
.XValues = someValues
End With

' second data series
Set ser = .SeriesCollection.NewSeries
With ser
.Values = someValues
.XValues = someValues
End With

View 2 Replies View Related

Macro To Set Border Line Styles

Jan 26, 2007

I have a range of data (not a named range, just a selection) and I typically want:

- the top 2 rows to have a heavy border on the left, top and right sides with a light line on the bottom.

- On the bottom line, I need a heavy line on the left, bottom and right sides.

- The body in between needs to have heavy lines on the left and right sides with dots for all in between.

The top 2 lines show titles, the bottom line is for totals and the body in between shows the data.

I've made 3 separate macros that do each part but I'm hoping that they can be integrated into one.

View 9 Replies View Related

Bar Chart With Marker

Feb 16, 2007

to create a chart which shows a current value in relation to it's annual high and annual low. I've created a bar chart and added a series with a value of 100. The next series I added is the value of the marker I would like to ride along the bar.

My question is how do I change the marker value series from a bar to just a marker? I would like the chart to look like this (except a bar, not a line):
__________

View 9 Replies View Related

Excel Min And Max Lines

Aug 15, 2012

In Column B I have some measurements. These are measurements. I chart them in a line graph. I also have my max and min over in some other cells. These aren't the min and max of column, but these are what I have set the min and max at. To make this clearer, my max is 27, but the data in Column B could be anything....20, 28, 35, 15, etc.

I want to plot my data in Column B just as I am currently doing. However I also want to plot the min and max on that same line graph and show them has horizontal lines going across. That way, if one of my numbers is above the max (or below the min), you will be able to see it on the line graph.

Here's what my data looks like. The Viscosity (column b) is what I'm charting on the line graph and you can see the min and max data that I want to plot as well.

Sheet1

*
A
B
G
H
I
J

2
Batch No.
Viscosity
*
*
Min
Max

3
4028634
26.7
*
Viscosity
21
27

[Code] .......

View 9 Replies View Related

Vary Data Marker Size By Value?

Apr 17, 2014

Is it possible to vary the size of data markers (eg spots) in a chart by their value?

View 2 Replies View Related

Automate Marker Options In Spreadsheet?

Jul 2, 2014

I have a scatter plot in which there are, for example, twenty plotted points representing one of three major categories.

We're using a red square, green triangle and blue circle to represent our categories on the graph. Going in to every plot point and manually changing each point so that it has the proper color and style is very time consuming.

Is there a way to designate in the spreadsheet (in its own column or something) that I always want the plot point to be represented in a certain way (like a red square) when graphed?

View 4 Replies View Related

How Do I Modify The Comment Marker/symbol

Nov 15, 2008

I would like to insert images (like a questionmark symbol) into a spreadsheet I'm working on, and then when the user hovers the mouse over the questionmark a "help-text" pops up. I've noticed that it doesn't seem to be that simple making a tooltip, however, is it possible to replace the small red triangle that is inserted into the sheet to indicate a comment with an image?

View 14 Replies View Related

Image As Custom Xy Chart Marker

Oct 19, 2007

I'm trying to use an image as a custom marker on an XY scatter chart. The jpg image is embedded on a separate worksheet and when I copy and paste it via code it seems to be arbitrarily resized. I've also tried to resize the embedded image and set the marker size but it always appears about 3 times the size of the original image. See CASE -0.5 below.

Set seriespoint = chtBaseArea.SeriesCollection(" Events").Points

For i = 1 To rngCombPointsY.Rows.Count
With seriespoint(i)
.HasDataLabel = True
.ApplyDataLabels Type:=xlDataLabelsShowLabel
.DataLabel.Text = rngCombPoints. Cells(i, 1).Value
.DataLabel.Position = xlLabelPositionAbove
.DataLabel.Font.Bold = True
.DataLabel.Font.Size = 8

Select Case rngVehicleY.Cells(i, 1).Value

Case -0.5
Set shpTemp = wrkshtGraphics.Shapes("Soyuz_Small_Icon")
shpTemp.Copy
.Paste
.MarkerSize = 10

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved