1. 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()...
  2. 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??
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. I

    Trend cursor on Excel Chart

    I have 3 charts in a worksheet. All of the charts share the same x axis. I would like to a trend cursor to each of the charts to clearing indicate the y value for each of the charts at the x-value the mouse pointer is located at. There are probably several parts to this question. but looking...
  10. A

    Chart expanding

    Hi Folks, I am currently working on pivot tables and charts. I have charts on one sheet and when I copy a pivot table and paste it onto the charts sheets the charts expand. How can I prevent the charts from expanding when I copy the pivot table or for that matter any text. The expansion is...
  11. F

    Combine three bar charts into one, with stacked bars..?

    Hi Everyone, I got this problem, where I have answers from a questionnaire, and I have calculated results in percent. I would like to show them in a stacked bar chart. In the attached file, I just made a example. I know the charts are two different types, but how do I combine them into one...
  12. M

    Multiple Pivot Charts With Linked Filter

    I have 3 pivot charts each with their own data source. The tables are all set up the exact same way. They have the exact same layout, just different numbers whether it's referencing a 6 month, 12 month, or 2 year projection. What I am trying to accomplish is I have all 3 pivot charts displayed...
  13. S

    Lock progress chart to a specific cell

    Hi, I think this might be easy or just not possible. I am creating a training matrix for my company to drive competence and have started an excel document. The progress charts show progress and will help set targets. The problem I have is when I insert a new row, adjust size etc, all my...
  14. N

    Excel worksheet in Teams

    Hi all, My workplace has recently moved across to O365 and use Teams. Within our Sharepoint file structure/Teams, we have a workbook that is manually updated each week. In the workbook, I have a sheet, called 'Dashboard'. On it there are a series of view only charts. Does anyone know how I can...
  15. B

    Pull a specific data range from spreadsheet and offset when the month changes??

    Good afternoon all, I want to select 3 columns of data from my spreadsheet which will be displayed in a chart on my dashboard, for example Column headers are Jun 19/Jul 19/Aug 19, when I get in to the month of September I want the selection to move along one column and then select Jul 19/Aug...
  16. P

    VBA Chart Formatting to Loop Through all Charts in Workbook

    I have a large dashboard that once complete will have c300 pie charts and need them all to have specific formatting. I have recorded a macro of me applying the formatting to one chart and looked up a macro to loop through all charts in the workbook and tried to combine the two to create the...
  17. T

    Is there a way to find a lost chart object?

    I created a chart but can't find it. Is there a way to find charts? It just has a generic name like "Chart1", "Chart2" etc. I thought maybe the selection pane would help. On it i've tried selecting or double-clicking the objects that are listed, but nothing really happens when selecting an...
  18. C

    Combine Rolling Chart and Dynamic Chart with Combobox.

    Good Morning, I am attempting to combine a Dynamic rolling chart with aCombo box to select different data streams. For example: The data sheet has sales volumes for 3 customers frompast 36 months I have been able to produce a rolling chart using OFFSETformula and named ranges which...
  19. L

    Year on year dates but next to each other on a chart

    Hi all, first time poster, long time lurker! I'm currently fighting with a dataset at work, where I need to show Jan-18 & Jan-19 data next to each other. However, no matter how I arrange my data set, the Jan-19 goes to the other side. Now, I get that it's following the sequential months/year...
  20. T

    Create a filter for a slicer based on if the sum of values is not equal to zero when a timeline changes

    I have a general question about how to set up a slicer used with several power pivot charts. I have two charts that share a timeline and display company totals and I have a slicer that allows for individual vendors to be selected. Everything works as intended, the only problem is that for this...

Some videos you may like

This Week's Hot Topics