chart

I would like to add a yellow outline to a bubble if any of the three values used to create it are between 50-75. This will be a bubble chart with several slicers so the need for a yellow outline will be a moving target. Any way I can achieve this? My data set up (from a pivot) looks like the...

Morning all, another day, another problem... So lets just say that we have: Workbook_one.xlsx basic daily export out of database with only one sheet. Lots of data, hard to read. Number of rows varies, number of columns stay same. Workbook_two.xlsm this workbook is used for processing the...

hello guys i have a problem with a rescale chart, if someone could help me. the problem is, i am plotting a line chart with a determined period of data, so when I change the period a straight line appears on the chart. I will post images of it. the first two images are the problem which I have...

Hi, ask you for help. I have 2 columns of data, pretty simple (screenshot and attached file): I want to make a chart of it. I've made a drawing of an idea of the chart, I have in imagination, a chart that can clearly represent such a big range of values (pic.) How to achieve this? (Workbook on...

So i'm stuck on grating a pivot chart / chart for showing average / high / low trends on time from creation of a supportcase until it is closes. What i would like to have in a chart is how average hours from creation to resolved changes over time. I'm totally stuck on this, so any input is...

Hiya, so thanks to some of you I'm 99% done with my pet project! I have only one tiny thing left that I can't for the life of me figure out. My below code selects a range based on a criteria, copies that range, pastes it into a chart, then exports the chart as a .jpg to a specified folder...

Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to merge them into only 1 chart. I have no intention of combining the raw data together because we are resetting the data from both tables weekly. So what...

I have a clustered column chart, with values ranging from 0-10. And I am currently showing integer values in the y axis, but I wish to show rankings rather than values. so for 0-2.5, D, from >2.5 and<=5, C, from >5 and <=7.5, B, and >7.5 A. I would like to show these rankings in the y axis...

Hi all, I have created a chart based on a table. We can see that in first foto there are no value entries, and in second foto values were added. Into the third foto, with rows only partially completed values, chart is going on 0 line from where values end. I need the red line to stop where...

I have an issue with the scroll bar when I click on the left or the right arrow to move just by one increment at a time the scroll bar keeps moving without stopping until I move the cursor from the arrow on the scroll bar (I am using just 1 at the incremental change in the scroll bar format...

Dear Team, Can anyone help me in creating a chart with below requirement to show in a better way; Example: Project Name Function Name FY Budget YTD Budget YTD Actuals Variances Project A Sub Function 1 100 80 60 -20 Sub Function 2 200 90 100 10 Sub Function 3 300 140 150 10...

I am using Power Pivot in Excel Office 365 and created a bar chart that currently shows the count as the label. I would like to show the label as a percent. The problem is I have the chart filtered to show only the top 8 items by count and when I convert the label to a percent of total, it is...

This is a continuation of the article mentioned below; instead of updating, I decided to create another one. Now there is an option to make a top to bottom chart. As before, the source table goes on a sheet named “fshap”. You need to insert two sheets named “tdata” and “secdata”. Part 1 Dim...

I'm new to VBA and I dont know how to create a sub that makes a PivotTable Chart appear with a Title, Axis Title, and extended size also. Can anyone help?

I am using Power Query to automatically download historical stock price data from Yahoo! Finance into Excel. The URL is Invesco QQQ Trust, Series 1 (QQQ) Stock Historical Prices & Data - Yahoo Finance It populates a worksheet with a year's worth of stock prices with the following columns...

Hi, I'm trying to create charts and need help with how to create neat and interactive charts to impress the board members. What I have are below data and my current charts that I don't think it's impressive: First Chart: Data: Country Jan-20 Jun-20 Change AA 3,486 2,341 0.11% BB 194...

Smart art can create organization charts, but it will have formatting limitations; the code below overcomes that. Prepare a source table containing the following information: Columns A and B – the relationships between two elements. The shape fill color will come from column A. Column C –...

i work for a pharmaceutical company. Please help me draw a graph. For a given reactor, if batch reaction time is "x hrs" and it will keep continuing all along the days may be for "y hrs" also. Plot a graph with "date" on X-Axis and batch reaction time ( x hrs or y hrs) along the length of...

I have a code that changes the range of data for a chart as more values are entered. I want the user to enter their values and the chart to automatically update but am unsure how to do this. The code works fine when i manually run it, so the only challenge is making it run by itself. Any help...

Hi there, I have an Excel spreadsheet and a Word document that work in pair. The spreadsheet is reviewed and updated regularly so the charts there represent the most up-to-date information. On the other hand, the Word document which contains the same charts (previously pasted as pictures)...