1. S

    Changing Multiple chart references within a selection

    I have a macro that goes through all the charts in my workbook and changes the series inputs (in this case would change row 18 reference to row 19 but can obviously be amended as needed) I'd like to amend this macro so that I can just amend the charts in my selection instead of the entire...
  2. A

    Populate Column based on date range

    Hi all, I'm wondering if anyone is able to help me. This is driving me crazy! I have multiple charts which contain environmental monitoring data: These are based upon data pulled from colums containing dates sampling took place and then adjacent columns containing microbial colony counts. for...
  3. M

    Editing a filtered Chart Series using SeriesCollection

    I'm trying to write backwards compatible code to allow me to access a filtered series on a chart without using the FullSeriesCollection (available 2013 +) object. However, the normal SeriesCollection object doesn't have access to series that have been filtered out of the chart. Is there a way...
  4. I

    How do I make this comparison to peer graph?

    I need to make something like this in Excel. Four shades (I'll change the color) indicating quartiles - just four even shapes to represent. The numbers on the bottom represent the quartile value. The yellow marker is where the person is on that said scale. I've tried stacked columns and...
  5. L

    Chart range that skips non-numerical data points

    Hi all, I am trying to make a chart that skips points that are not numbers. For the x-axis my values are coming from this named range formula (paintMSdatapointnumber) which shows the last specified number of values. =OFFSET(' Paint'!$A$14,COUNT(' Paint'!$A:$A),0,-' Paint'!$X$11,1) I thought...
  6. T

    Macro to move chart data series reference down one row for all charts and all series in workbook.

    Hi guys I have a number of line charts, some with one series some with multiple. There are around 70 of these charts which plot a variable over the past year from table on another worksheet. The table has months down the columns with a value for each location of the variable. See attached. Just...
  7. H

    Macro to Change Y Axis Scale for All Selected Charts

    I'm trying to create a macro where a user can select multiple charts on a worksheet, and then upon running the macro, enter the desired Min, Max, and Major Unit values for the Y-Axes for the selected charts. All charts would have the same Y-Axes. I found the following code snippet to loop...
  8. R

    Using a Named Range in a Chart

    Hi Everyone, I'm trying to embed a named range in a radar chart. The Chart Data Range is ='Raw Data'!$D$32:$X$33,'Raw Data'!$D$36:$X$36 The Name is ='Raw Data'!$D$36 Y Values are ='Raw Data'!$E$36:$X$36 Horizontal Axis labels are ='Raw Data'!$E$32:$X$33 I've got a Named Range called...
  9. C

    Creating chart from table with multiple series

    Hey, I have a table that has costs of 3 sample products. Each month, the cost is recaclulated for the 3 parts and added to the end of the table. I want to create a chart for each part number showing how the cost has changed each month, but I don't know how to get the chart to choose just 1...
  10. E

    Format the selected series in Chart in Powerpoint

    I would like to create the macro which will format the selected "DATA LABELS" in chart in powerpoint. Below is my code. But the problem is Im not able to write code for selected "Data Labels". Please assist Sub testSelection2() Dim shp As Shape Dim count As Integer Dim left_count As Double...
  11. K

    Charts changing section colors with slicers

    Hello! I have an interesting problem that I am occurring. I have created some charts that is looking at racial data through pivots. When using some slicers to within the data that I have, it takes away some of the racial information that is located. You can see with the images below. While...
  12. DRSteele

    North American Stock Market Indexes with 52-Week Performance Chart

    With the intention to help those struggling to find stock names and symbols for Data Types | Stocks, I put in some effort. I have uploaded to OneDrive a file containing all the stocks in the TSX Composite, the Dow Jones Industrial Average, the S&P500 and the NASDAQ100, current as of December 29...
  13. S

    VBA - Save Charts with Chart Title as Name

    Hi, I'd like to be able to save all Charts in a sheet with their Chart Title as their name, for some reason this is proving more difficult than expected. I believe it's the Title = part of the code that needs to be changed. Any help would be appreciated. Code: Sub ExportSheetCharts()...
  14. C

    Can I somehow Trace Dependents that are in a chart?

    The MS page says that formulae in an embedded chart is not used for tracing dependents. But I find that, even with a non-embedded chart, plotted variables are not traced. Is this to be expected? It seems that a chart is not a formula! Is there a work-around??
  15. Worf

    Double chart animation with VBA

    The charts below represent the water level in two tanks. Each one has two series of stacked columns, and the data cells are A1 and B1. There is a link to the workbook on this post. The idea is to transfer water from one tank to another, so just enter a percent level variation for one tank, like...
  16. S

    Count chartbjects from multiple sheets in a excel file

    I have 3 charts in three different sheets in excel workbook. I want to count the number of charts present in excel workbook. I have tried activesheet.chartobjects.count It gives the count of charts present in that particular sheet. Can anyone has solution to count all the charts present across...
  17. masud8956

    Problem refreshing charts in multiple sheets depended on data from specific sheets

    Hi, I have some data involving dates {including =TODAY()} and numbers in Sheet1 and 2. Sheet 2 is hidden from view. in Sheets 3, 4 and 5, I have several charts (Line, Doughnut and bar chart). The line chart is located at Sheet3 getting data from Sheet2 only (hidden sheet). Doughnut chart is...
  18. J

    Edit chart category axis data items visible in VBA

    HI all, I have a workbook that crates a group of charts on a single worksheet. Each chart is based on 39 weeks' of data, but I want to show the last 8 weeks only, or be able to switch all the charts to show week 7, 15, 22 etc (it is school data, so weekly for now, but eventually the end of each...
  19. N

    Use VBA to modify Chart series data

    Hi, I have an excel model that I have built that displays YTD data on a weekly basis in the form of graphs. There are a 7 of different tabs, 5 are for each individual site, 1 is a combined tab, 1 is for comparisons and the final one displays retail data. My question is whether or not it is...
  20. K

    Data Extraction From Web Charts Through VBA Coding

    Hi Team, I am trying to extract data from web charts. If we hover on charts we are able to see the values of each field. So, for this I have to note down all the values in excel sheet. This is really time taking. for your reference purpose in the below web address there is trend chart, if we...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back