chart

How To make Hyperlink >Workbook File > Sheet 1 (Particular sheet link) # i try excel file create other excel file to particular sheet hyperlink making...... Pleased help me

Hello all My question is related to charting a set of data in a specific way that I can clarify as we go on, but the jist of it is included below, I am in a bit of a pickle with a task I have to convert some MATLAB code into VBA. Usually my methodology to do this is to develop each chart...

hello to all. I am trying to create a script that extracts chart elements (in jpg) from excel to sharepoint. I'm currently using this script but without results: function main(workbook: ExcelScript.Workbook): ReportImages {...

Hey everyone, I have a fixed table with dates (x-axis on desired chart) that go for several years into the future, but data (y-axis) that only goes a few months. This will be a working file where new data is added each month. I'd like an area chart to show the data across the dates that have...

Hello, I am a newbie working with VBA on Excel. I have been trying to figure out to create a pie chart and a column chart using the following data to show expenses by locations. How would I create a chart that shows expenses based on each location in VBA? Distribution Centers Budget Proposal...

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