chart

Hello, I'm trying to create an area graph to shade each range percentage listed in the far left column (pictured) a different color. Rage A - shade anything above 15% one color Range B - shade 5 - 15% a different color Range C - shade -10 - 5% a different color Range D - shade anything...

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.

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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

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

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...

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...

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...

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...

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...

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...