chart

I am not sure if this is possible in excel but... I have my data set up as Date, Event 1 Start Time, Event 1 Duration, Event 1 End Time, Event 2 Start Time, Event 2 Duration, Event 2 End Time. (see image) What I would like is a scatter chart with Date on the x-axis. I want all the dates from...

Hello, I'm new here and I need help. I have a very important meeting at my company on Tuesday which can possibly give me the promotion that I have been waiting for. The thing is our CEO is going to convince stakeholders of the company about something and for that he has chosen me to accompany...

Hi, I am trying to format a cell with 2 types of formatting conditions that will display correctly on a chart. For instance if the cell is below 1000 I want it to use the standard number formatting, but if the cell is between 1000 -10000 I need it to look like 2.5k and for anything over 10000 I...

Hi I have the following picot table which I want to visualise as a Pie chart with a breakout bar chart. I want the Pie Chart to show Low, Medium and High and then have a breakout bar chart showing the Account Names that make up the High clients. Here's my pivot table Which is based off of...

Hello guys! How can I fix an issue in Excel where the percentage displayed on a bar chart is disproportionate to the actual value? This is my pivot table that contains the data. This is my graph where the light blue bar should be much smaller, considering the values of 2.56% and 2.05%...

In the table in Columns F, G, H, this is the "final result" of the data, and I've plotted a simple line graph for Column F and Column H. I noticed there's some sort of (exponential?) growth decay for Column H? Is there a (mathematical) way to get an equation/formula for the 2 curves? In the...

Hello I have a lot of messages (300 approx) between myself and my bank that span a 1-2 year period. I want to enter all these messages into some sort of timeline, chart. That starts from the first message and progresses thru to the last message. I guess some sort of excel flowchart, or message...

How do I go about creating a vba macro that reads data from a sheet in order to create a chart? in the sheet below my test data is found in columns a,b with details in rows 2-8. However in the real data my rows will be much more. Add a new sheet to insert the chart. Thanks Date Color...

Is it possible to create candlestick chart from a PivotTable? I just can't find out how to arrange the data to be able to create a candlestick chart. I only get "You can't create this chart type inside a PivotTable". I have the PivotTable connected to a database connection and it would be...

I'm having trouble with my chart creation macro and would greatly appreciate any help. I want it to import data from the sourcesheet and create a chart for each row (macro is working for it); however, I'm trying to make my macro to edit the charts and not include a specific year if it has...

Dear Excel expert, Can you please kindly help me to find out a way to draw a graph like this

I am copying a chart from tab 2023 to tab 2024 in my workbook. When I do this the table in tab 2024 references the data in tab 2023. Is there a way to get the location of the data to change with the tab name.

Hi all, I am wanting to use VBA to insert multiple charts into one worksheet in specific spaces. I have a chart template created already as the same chart will be used for each. Here is a photo to help explain what I'm wanting to do. I want to use the data in each row to create a bar chart...

This might be a simple question but I am looking to make a bar graph using what is in the data picture The scale I am looking to use is the second picture - with 1 being completely false and 7 being completely true. In the graph I am looking to have the graph show completely false at the bottom...

I have the below data, where column 1 is a date, column 2 is a location # of computers, and Column 3 is a location. The order of the columns doesn't matter. I would like to chart the location and number of computers at that location over time, showing a shift from one location to another...

Good morning, everyone! I am trying to create a dynamic chart in Excel. However, I want to hide the columns in Bar chart with contains zeros because it looks too much crowdy. I used the zero filters, but it hides for me the whole column. my problem that each category has 4 bar chart I just want...

Hi all, I am trying to figure out how to best visualize 5 years of monthly data of sales figures across 40 departments, where the goal is to find trends in a given month-year combination for a department (and perhaps ideally, comparing across the 40 departments for the 5 years of month-year...

Hi All, I would like to fill colours of each bar based on values available in column A using VBA. Please see below image. I can simply fill the colour manually, but i would like to do using VBA because I am producing same kind of chart where more bars adds or removes so colours on bar graphs...

I have an Excel scatterplot with a number of 2-point series. I am trying to set the position of each DataLabel in VBA, but its behavior is unpredictable. Here is the result, with each label text showing the (.Left, .Top) value that was set: I would expect every label with .Left = 100 to be...

I created a complex chart on Sheet 1 but need to move it to a clean sheet 2. How do I do it? jgb