All Questions
50
questions
1
vote
0
answers
193
views
Is there a way to show horizontal and vertical gridlines on a Surface Contour chart?
I am creating a chart of type xlSurfaceTopView in VBA. I want the chart to have horizontal and vertical gridlines, but the last two lines of the following With statement only cause two gridlines to ...
- 11
1
vote
0
answers
38
views
How to filter rows for a pivot chart to ensure one to one relationship in results
I am trying to put together a PivotChart as such:
Each recipe is made up of ingredients. Each ingredient maps to (potentially) many products. Croissant Dough for instance calls for 40g of butter. ...
- 121
1
vote
1
answer
1k
views
Create a histogram in a cell based on condition
I need a histogram in a cell based on condition.
Example:
In:
Input
My Out:
My Output
Needed Out:
Needed Output
So, If I'm using conditional formatting and choosing histogram, I have no option to ...
- 13
2
votes
1
answer
1k
views
Colour Excel stacked chart series accurately from cell fill
(Using Excel 365 for Enterprise) I regularly create stacked column charts where the series are drawn from a fixed list of categories, and each category must have a specific (externally defined) colour....
- 163
0
votes
0
answers
61
views
How do I create a graph from two groups of data without selecting data row by row?
Say you have this data:
First group of data:
A B C D E
a 0 1 3 4 5
b 6 7 8 9 5
c 0 1 2 3 4
Second group of data:
A B C D E
a 1 1 5 4 5
b 6 8 8 5 5
...
- 131
1
vote
1
answer
72
views
MS Excel Plots not displaying correctly
This was originally asked here but has been voted for closure and moved to this site.
I have a dataset in excel like the following (starting at cell A1 going to D100)
| Part | MK_CREATED_DT | ...
- 113
0
votes
0
answers
48
views
VBA conditional line formatting
I have a chart with many series. There is a Series Collection titled ("Upper Limit"). If any other series in the chart crosses over that threshold, it needs to be changed to a dotted line. I get a run ...
1
vote
1
answer
469
views
Excel Chart Color - Create charts with conditional formatting on "text value"
I have a data set of Companies/Products with their performances for every quarter.
I am creating a lot of graph to display the various performance.
Problem:
In order to be coherent, I'd like
to ...
- 11
0
votes
1
answer
2k
views
VBA - Copy chart from excel to powerpoint without link (embed)
I have a macro that copies all charts from my Excel sheet into a new PowerPoint file.
The problem is that the charts update themselves if I use a filter while the Excel file is open. To prevent it, ...
- 1
1
vote
0
answers
144
views
establishing a specific graph color based on variables name
I'm looking for a way to set a specific color to a name when creating graphs (line, bar, and pie charts) using excel 2013.
For Example, I want to graph sales results for Anne, Jim, and Mike but want ...
- 11
0
votes
0
answers
558
views
VBA works with F8/F5 but fails when called from button/SUB
The basic code below works when I F8/F5 in the visual basic window. Some of it fails when I call it using a button in a worksheet, or from within another SUB (my final goal).
The part highlighted ...
- 1,538
0
votes
1
answer
1k
views
VBA code works with F8 but not when run
I have written some VBA code to insert an Embedded Picture into an Embedded Chart onto an Excel worksheet. The routine attempts to do this by copying the picture, adding an embedded chart, setting ...
- 11
1
vote
1
answer
2k
views
Exporting Access query to Excel using VBA and creating a secondary axis chart
In MS Access I have a database. I have Form with three TextBoxes and one Command Button.
In txttask_plot user writes Plotid
In txttask_from user selects date1
In txttask_to user selects date2
The ...
0
votes
1
answer
3k
views
create excel charts in separate sheet using vba
In Excel 2016, I am trying to write a vba sub that takes a worksheet containing some data and creates a new sheet which will be filled with charts that use the data in the original sheet.
I have ...
- 107
0
votes
1
answer
4k
views
Have Excel Chart only show current month and YTD
I’m currently working on creating a dynamic chart which is updated monthly in accordance with the information imported into the excel file.
The table is updated with the information, where the chart ...
- 33
1
vote
1
answer
3k
views
VBA error: -2147188160 when PasteSpecial a Shape
I've a vba procedure that call another procedure (addChart(cht, PptApp, oPres)), to add charts to a powerpoint presentation. When I run the full code, the procedure create a new ppt and paste the ...
- 111
3
votes
2
answers
14k
views
Plot rectangle using coordinates in Excel
I want to plot a Rectangle using Excel charts with help of only 2 coordinates, bottom left and top right.
Is there a way I can define use the Microsoft Office 365 Pro plus Excel version.
For example:
...
- 131
2
votes
2
answers
698
views
Excel How can I visually turn off/on some of the series within a multiple scatter plot
I have a scatter plot with many series in it and for better understanding of the data, I would like to be able to sort them into categories and select for viewing only some of them to compare the ...
1
vote
0
answers
329
views
Error with CharObjects in VBA
The following VBA code adds a ChartObject to sheet "Feuil1" but also returns a generic 1004 error (error defined by the object).
Sub test()
Dim ch As ChartObject
Set ch = Worksheets("Feuil1")....
- 21
0
votes
1
answer
172
views
Using Text to Columns and make a graph from the selected range
What I'm trying to do is first I have a CSV file which has an enormous amount of data.
The first column A has Date and time separated by a space as 03/11/2017 12:55:34.
I want to select the cells ...
- 1
1
vote
1
answer
309
views
Conditional formatting changes number format - or does it?
The setup
I have two conditional formatting rules that apply to a range of cells. The rules are:
=R1C1="something" -> have the number format be Number
=R1C1<>"something" -> have the number ...
0
votes
1
answer
2k
views
Run-time error '1004' Method 'Rows' of Object_Global failed
I am writing VBA code for finding last_row of next sheet inside a chart sheet, in chart I a using Chart_MouseUp and Chart_MouseDown function here I am explaining Chart_MouseUp inside Chart_MouseDown ...
0
votes
2
answers
1k
views
How do I return the "Series" and "Point" names of a Stacked Column chart in Excel using VBA
I am exploring VBA in excel and would like to know how to get a hold of the Series and Point names from my stacked columns chart.
If you have a stacked column, you can hover over any column and excel ...
- 249
0
votes
1
answer
849
views
Excel 2013 - removing LegendEntry objects from a PivotChart Legend using VBA
I've got a PivotChart which typically shows 6-8 series out of a possible 15, many of which tend to be zero. So every time it refreshes, it has 15 series and the Legend only needs to list the series ...
- 554
0
votes
1
answer
634
views
Excel macro pauses using a timer, I want to use a button to restart it
How can I restart my macro using a click event, replacing my current timer method?
I have to manually update chart labels before I create a PDF to print. I've included a timer to pause the macro ...
- 1,538
2
votes
2
answers
2k
views
Excel chart - counting the series and then adding a data label to the last point
I've managed to make a macro that finds the last point of the first series in a chart and add and format a data label. I would now like to make it count the series, which may change in number, in the ...
- 1,538
0
votes
1
answer
556
views
Excel macro: replace entire worksheet with different values [closed]
Is it possible to replace entire worksheet with different values at the click of a button through macro? There are no "replace X with Y" or any recognizable pattern, I'm trying to replace ALL values ...
- 53
5
votes
2
answers
6k
views
Finding multiple local maxima and placing data labels on corresponding chart
Spectrum that I am using complete with 10,000 data points
I am a chemistry student of sorts and I frequently have instances where I need to find multiple peak heights (as seen in the attached picture)...
2
votes
2
answers
2k
views
Linking a chart series' name to a range through VBA
I would like to link the chart series' name to a range on my worksheet, but not the whole string in that range. For example, instead of linking the name to a cell that contains "201601", I want the ...
- 21
1
vote
0
answers
743
views
Format datatable using VBA (values are as Double but String is needed for formatting)
Currently working on a vba script that makes charts automatically. I would like to add a datatable which is done using:
.HasDataTable = True
However I would like to show the values of series as ...
- 81
2
votes
0
answers
1k
views
Programmatically rotate a pie chart to fix the labels
Part 1
I'm looking at a way to automatically rotate (with VBA) a pie chart depending on the data. The data is changed dynamically depending on the month selected. Here is an example of the kind of ...
- 504
0
votes
1
answer
4k
views
How do I keep formatting on an Excel 2010 Pivot Chart?
I have some VBA code that runs a SQL Query, dumps it into an Excel 2010 spreadsheet and refreshes the 2 Pivot Tables based off the data. I also have 2 Pivot Charts based off of the Pivot Tables, and ...
- 378
1
vote
2
answers
12k
views
Chart Series name referencing cell address Excel 2010 VBA
I am using Excel 2010.
I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...
- 133
0
votes
1
answer
763
views
Chart created from range of dates includes dates not in source data
I have a chart and its source data is read from a range which contains dates. When I plot it out into a chart, the x-axis includes dates that are not included in the range.
How do I avoid this?
For ...
- 382
1
vote
1
answer
278
views
Show increase in trendline by using Excel vba
I have data in c5:c12 (sales1) and I plotted a graph and a trendline of this data. I also have data in d5:d12 (sales2). I would like to show an increase, graphically, in my existing trendline by using ...
1
vote
2
answers
908
views
Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet
This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...
- 137
3
votes
3
answers
44k
views
How to use Excel 2010 VBA to set series line color, marker fill, and marker line color
I am trying to write an Excel 2010 VBA subroutine to format charts according to a predefined (i.e., defined by me) standard. The particular attributes that I want to be able to set are merely the ...
- 147
1
vote
1
answer
2k
views
Using Chart BeforeDoubleClick with a chart object in worksheet
I am trying to get a macro to work on a chart in a worksheet using the Chart.BeforeDoubleClick event.
I have been able to use BeforeDoubleClick event (without the use of class modules) in a stand-...
- 137
-1
votes
2
answers
4k
views
how to create excel charts having strings in both x and y axis
I have a student data with Student Name and their grade (A/B/C/D/E.). Now I want to have a graph for this data.
Kindly help me.
0
votes
1
answer
2k
views
Excel 2007 VBA Export range as jpg file is truncating picture
I have a workbook with many different ranges of data with 77 lines or more. I need to copy them and save as JPG files, which will be used by another application.
Below is the example of code that I'm ...
- 1
1
vote
1
answer
2k
views
Offset the tickmarks of a secondary axis
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that ...
- 252
0
votes
0
answers
1k
views
Excel VBA updating graph data
I have several charts referencing off one particular dataset. Each chart has a different number of series. Each series refer to one particular row of the dataset for a certain number of columns (ie. ...
- 179
0
votes
1
answer
8k
views
ActiveSheet.ChartObjects("chart") always returns Nothing?
I'm querying for a chart in the worksheet and I can see it's there but everytime I execute the following piece of code it evaluates to 'Nothing'. Why is that?
Sub DeleteGraph()
Dim graph As ...
- 349
0
votes
1
answer
5k
views
Optimally positioning pie chart data labels in Excel with VBA
I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size.
I want to display the data labels ...
- 391
0
votes
1
answer
3k
views
Creating multiple plot per level of factor (trillis graph) in excel
Is there way to automate the process to make graphs like the following (also known as trallis graph) in excel ? I know there are some R interface with Excel (some of them need to be purchased), but I ...
- 113
1
vote
2
answers
8k
views
Change the Point Color in chart excel VBA
I'm trying to the get the points from a chart in excel vba? I made a chart of student marks in excel, and I want to put a condition i.e if marks on chart are greater then 90 then the point color ...
- 187
3
votes
4
answers
43k
views
How can I create proportionally-sized pie charts side-by-side in Excel 2007?
I have a pivot table with two sets of data as follows:
2011 2012
Slice A 45 20
Slice B 33 28
Slice C 22 2
I am trying to present two pie charts side-by-...
- 805
6
votes
3
answers
27k
views
Use a Trendline Formula to Get Values for Any Given X with Excel
Is there an easy way to apply the trend line formula from a chart to any given X value in Excel?
For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and ...
- 2,745
0
votes
1
answer
2k
views
Excel 2010: How to color the area between charts?
I asked this question already on stackoverflow but it hasn't been answered yet. Instead I was advised to try it here, so here I go :)
So there's that simple XY-Line-Chart in Excel (2010). It is ...
- 1
1
vote
2
answers
3k
views
Interacting w/ Graphs Using VBA in Word 2007
I have a long MS Word 2007 document, in which I occasionally need to replace all of the embedded graphs.
The changes are simple enough and regular enough that I could probably write a VBA macro to ...
- 993