charts

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. S

    Excel Charts into Word

    I have an excel doc that has 15 charts in it, I can export the charts into word but does anyone know if its possible to place them into specific parts of the word document? If is it possible could someone point me in the right direction of code to use? I have tried several different ones (like...
  19. J

    Macro keeps creating a charts for interger 2 rather than looping down a list.

    So I have a basic Macro to select some data and create a chart - this works perfectly. The problem I have is that I need to create 78 of these charts. I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and...
  20. J

    One line Gantt Charts

    Gantt charts typical display a different task or job on different lines. So one project will have five lines if it has five different phases. It it possible to create a Gantt chart with all phases on one line? I want to be able to look at different projects and see how their timelines match up...

Some videos you may like

This Week's Hot Topics

Top