1. S

    VBA Dynamic Print to PDF

    Hello, I need a bit of help with VBA. I've been programming in VBA for about a year, and I come here very often to find answers for questions I might have, but this one is stumping me. I'm developing a product where people in my org can use different templates to create different charts. Each...
  2. oriwitt

    Graph from multiple data series

    Hi, I have multiple data series provided from a source in a format similar to SeriesName1 NameTitle DataPoint1Title DataPoint2Title DataPoint3Title Person1 DataPoint1 DataPoint2 DataPoint3 Person2 DataPoint1 DataPoint2 DataPoint3 etc SeriesName2 NameTitle DataPoint1Title DataPoint2Title...
  3. R

    VBA to reset existing charts with column data from another sheet and rename legend

    I would greatly appreciate your help with charts. I'm new to VBA and I just don't understand how to apply information from other posts to my issue. I have 3 line charts and 3 column charts on Sheet 1. The data on sheet 2 is by month and updated monthly; therefore, the number of rows change month...
  4. Jyggalag

    Color the area inbetween two lines in a chart/graph?

    Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...
  5. E

    Slicer not working on Chart in VBA, but works after selecting chart data manually

    I created a VBA script that adds charts and slicers to my worksheet, but for some reason they don't work after adding them. Now, once the charts and slicers are added I would go and select on the chart, right click and click "select data" then click ok. Once I do that the slicers work with the...
  6. G

    Loop to create charts automatically

    Hi folks, I am not very versant with chart objects and keep getting stuck with the following problem. Thanks for your help! I have put a simple version of a minisheet below with data. I could not figure out how to capture the charts in the minisheet so an image of the "desired result" is...
  7. D

    Vertical value and range chart

    First time I'm creating a post as I think I'm usually okay at finding solutions in Excel, but this has got me scratching my head. I'm trying to create a chart that shows a vertical list of categories that each have a value, and whiskers that plot the range in which the category values should be...
  8. J

    VBA Excel - Charts - how can you determine if a line series is dotted or dashed

    Hi, I work on a tool that formats Excel charts for best fit to a powerpoint template. My organisation produces projections on different kinds of topics. We make lots of graphs with dotted series for the projection period. Before copy to Powerpoint it is necessary to tweak the dotted series so...
  9. P

    Splitting Large Charts into Multiple Pages

    Dear Excel Experts -- I have a stacked bar chart that I am working with that is starting to out grow even 11x17 (Tabloid) paper sizes. I was trying to figure out how to have excel split it so that it would span multiple pages. Ideally I would like to have the data table on the chart also...
  10. C

    Getting duration data (MM:SS) to appear on a chart axis

    Hello. I am trying to chart the monthly median duration of a project and while I can chart everything perfectly using columns B and D (Month and Seconds - see first image below) what I really want to do, is use the data from columns B and C (Month and MM:SS). For clarity, the figures in column...
  11. N

    VBA: Generate Charts, copy/paste multiple charts to same Sheet

    Fairly noob here. I have a list of Person names on another sheet. I want to automate building a separate monthly trend chart for each person and paste them all onto a new sheet, one right after the other. Will this code work? Worksheets("Report").Range("A4").Value = Agent Call...
  12. W

    Creating Multiple Charts using VBA

    Newbie here. I'm trying to create multiple charts (i.e. different chart objects with one graph on each). I found a code on youtube that is linked in the comment that I'm modifying. For now I want to be able to give StartRow which is a starting point and create a scatter plot of the next 700...
  13. C

    using data to create the series label in Excel on X Y Scatter

    I’m trying to use the data (see images below) to have three data points for each dot on the scatter diagram. I need each series element to be custom selected data (not fixed label) so that when I hover over the dot all three data points are visible. I can do this manually; however, I want to do...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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