chart

  1. P

    Deleting every chart sheet

    Hi guys, I have this little VBA code which deleted all my worksheet except those I listed there. My question is how to make this delete the chart sheets too. I have some sheets which is only a chart, VBA sees it as chart but I want to delete those too.
  2. L

    Data not sorted correctly in Chart and Select Data Source greyed out

    Hello all, I'm writing this because I am stuck and cannot figure out where 2 issues come from of some Charts I've been working on and how I can fix them. I am using M365. I've been checking for various causes and solutions online in the last few days and unfortunately, I could not figure it out...
  3. S

    Can't plot a simple chart

    Hey! I'm trying to plot a trivial chart as shown below and can't still get it :/ Help would be appreciated.
  4. U

    Excel bar chart

    Hi All, USing below as an example, im attempting to create a bar chart with only 2 bars but using all of the below data. So on the left hand side (y axis) will be the months, and the x-axis along the bottom will be the value scale going up in whatever say 1000s. The thing is I want 2 bars...
  5. L

    Parallel Item Chart

    Hi, I want to create a chart like this. If items are in series the blocks should come one after the other on the same row. And if an overlapping item comes next then the block corresponding to it should come on the next row. For example, if there are 100 items coming in series then 100 boxes...
  6. A

    Find intersection of two independent ranges and sum values at every coordinate

    Hi All, I have the definition of several ranges of straight lines: 1, 2, 3, 4 and 5, where I define the x- and the y- coordinates only for the start and end points of the lines. I would like to have a "Desired" range that sums the values in every coordinate of the range. I would like to do this...
  7. D

    One year slicer to control two different pivot charts with different date columns but same data source?

    Hey, I have an excel table with invoices. Invoices has two dates, one is the date of completion, the other is the date when the invoice was actually paid. I need two different charts from this. One that shows revenues according to the first date, and one that shows revenues according to the...
  8. P

    Plotting a dynamic amount of series on a chart

    Hi, Long time lurker first time question poster here :) I'm trying to plot a variable amount of series on a chart. I've created a dummy environment with data for my issue, however in the actual issues case, the data table in B29:R47 is filtered from a master on another sheet which I cannot...
  9. C

    Create Cluster Chart that Updates Automatically with New Data

    I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...
  10. C

    Create Cluster Chart that Updates Automatically with New Data

    I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...
  11. S

    Excel equation for dates past a certain date

    Help please if you can, I cant seem to find anywhere else. Im trying to find the equation for 2 things, 1. I have a chart I'm making and trying to calculate if something is past due 30 days, 10days, and 5 days is there an equation to find out if the dates I entered have passed...
  12. D

    Charts: Data series displays 2% value bigger than 98% (100% stacked chart)

    Hello, can anyone help me edit my chart so that it shows data series' size proportionally to its value? As you can se on a screenshot below; bar on the right visualizes 2,27% as bigger than 97,56
  13. Jyggalag

    Remove value from chart without changing chart values?

    Hi all, How do I disconnect my chart from the values next to it, without changing the charts values? thanks!
  14. B

    Using variables to place the chart on the spreadsheet

    Hi, I draw multiple charts on a spreadsheet. for placing them I use this code: Set rng: Activesheet.Range(A100:N125) that draws me a 25-row high chart to A 100 to N125, working fine when not all the charts are required, I want to be able to select them and place them automatically in the...
  15. S

    Forecast 'S Curve' with only Start & Finish Values over a Given Time Period

    Hi, please help. I'm not sure if this is even possible. I am trying to create an "S Curve" chart as a predicted forecast. The only data I have is Years to go on the X Axis and "Start / Finish" values for the Y Axis. X Axis Y Axis 2022 0 2023 2024 2025 2026 2027 2028 150000...
  16. P

    Horizontal Error Bars - uniform length and data labels for endcaps

    Hi, I'm trying to create line graphs that show where a current value is along a range. I've decided to go with XY Scatter and add error bars with caps. Data and images below, running into the following problems: - I created the charts via VBA and anchored them to the corners of the cells I...
  17. A

    Links from Excel to PowerPoint break

    Hi everyone, I am having some trouble regarding linked charts copied from Excel into PowerPoint. I am working on a powerpoint template, with several charts created in a separate excel file (located in the same folder). I want to be able to update the excel file, and for the powerpoint to...
  18. F

    Excel Chart x-axis label interval with start value offset

    Hi everyone, I got this bar-chart with x-axis labels of which I only want to show every 3rd item, but I also would like to start at the 2nd item of the list. now I got 1,4,7,10,... and I like it do show 2,5,8,11, but still chart data from 1, just the label needs an offset of 1. (VBA...
  19. I

    Top x historical chart dilemma

    Hello All, Have a question on how Excel creates charts. Input data: - Daily 'topics' with values. - Topics can vary daily. - Values can vary daily. I create a chart that shows ALL data from lets say January. - March 3rd, AND I choose the top 5 to view. My question is, at the bottom of the...
  20. B

    Excel Visual Chart

    Hi, I'm looking for help designing a chart to show a sales chart along different data sets. I want the chart to show Sales, Profits, from two different revenue stream and for each time period. How can I design a chart to show all the data in one chart? Item Sales Profits Sales Profits...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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 MrExcel.com.
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 "mrexcel.com".
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
Top