Hello,

I have two Pivot Data Filters: one for Part Number and one for Description. (Item: 111, Description: Part B | Item: 222, Description: Part A)

Each of them is sorted alphabetically so, for each line, the description doesn't match the item. Here is an example (imagine these are sets of Pivot Data Filters).

Item Description

111 Part A

222 Part B

Do you have any suggestion on how to relate the two fields in order that Description**follows **the right Part Number?

Item Description

111 Part B

222 Part A

I know I could solve the problem with a concatenated field but the file is very complex with a lot of macro running on. Moving columns at the moment it is not that easy.

Thanks for the help!

]]>I have two Pivot Data Filters: one for Part Number and one for Description. (Item: 111, Description: Part B | Item: 222, Description: Part A)

Each of them is sorted alphabetically so, for each line, the description doesn't match the item. Here is an example (imagine these are sets of Pivot Data Filters).

Item Description

111 Part A

222 Part B

Do you have any suggestion on how to relate the two fields in order that Description

Item Description

111 Part B

222 Part A

I know I could solve the problem with a concatenated field but the file is very complex with a lot of macro running on. Moving columns at the moment it is not that easy.

Thanks for the help!

I need to create a chart in Excel 2019 as shown in the attached image.3.8.png

]]>Good morning everyone,

attached you'll find what i have manually done so far

I need a chart that updates its ranges automatically given what's inside the cells Y2 and BF2

Can anybody help me with this?

Thanks!

attached you'll find what i have manually done so far

I need a chart that updates its ranges automatically given what's inside the cells Y2 and BF2

Can anybody help me with this?

Thanks!

I have a simple chart that has 5 elements and 6 data points for each element. I want to show 4 of the elements as a bar and one as a line... When I try to do this, excel keeps on setting up 3 as a bar and and 2 as a line. That does not help me. What am I missing?

I have attached a file to show the problem

I have attached a file to show the problem

Hello,

Given the graph attached in this post:

Dark blue plotted line -> r=0

orange plotted line -> r=1

gray plotted line -> r=2

yellow plotted line -> r=3

light blue plotted line -> r=4

Those lines are plotted by known values (Graph is from a source and any value is known)

I need some help by getting my 'r' value by a calculated X and Y value. For example (as seen in the picture): If X is calculated at 0,15 and Y is calculated at 0.83, r should be ~1,5 (in the mid of the orange (r=1) and gray (r=2) lines.

Is there any way to do this in Excel?

EDIT: Excel file is attached, all information is inside of the file if wanted.

Image excel.png

Given the graph attached in this post:

Dark blue plotted line -> r=0

orange plotted line -> r=1

gray plotted line -> r=2

yellow plotted line -> r=3

light blue plotted line -> r=4

Those lines are plotted by known values (Graph is from a source and any value is known)

I need some help by getting my 'r' value by a calculated X and Y value. For example (as seen in the picture): If X is calculated at 0,15 and Y is calculated at 0.83, r should be ~1,5 (in the mid of the orange (r=1) and gray (r=2) lines.

Is there any way to do this in Excel?

EDIT: Excel file is attached, all information is inside of the file if wanted.

Image excel.png

I would like to group the smallest entries in my Pivot Table together without altering the original data if possible. In my attached spreadsheet the tab named PivotTable1 shows how the data looks without grouping, PivotTable2 shows how I would like it to look but I had to alter the original data. When I display a pie chart the last entries become small and cluttered making the chart hard to read. My actual file has tens of thousands of rows and grows monthly so altering it isn't really a viable option. I searched through previous posts but was unable to find a previous solution, however I don't know if this process has a name so I may have easily overlooked it. Any help will be greatly appreciated, thanks.

I have an excel chart with 3 axis. I want to add a secondary horizontal axis.

I have a list of job numbers on the primary horizontal axis, i want to add the owner of each job on the secondary horizontal axis so i can see whos job is whos on the graph. How do i do this?

I dont want to add the owner on the primary horizontal axis because itll be too crowded. But if its on the top of the graph it would be perfect.

Thank you.

]]>I have a list of job numbers on the primary horizontal axis, i want to add the owner of each job on the secondary horizontal axis so i can see whos job is whos on the graph. How do i do this?

I dont want to add the owner on the primary horizontal axis because itll be too crowded. But if its on the top of the graph it would be perfect.

Thank you.

Hi there,

I've recently been upgraded to a new computer at work, which seems to have messed up my excel settings. When changing the data source anywhere outside of the existing range, the pivot table goes completely blank. For example, table range will be set to Sheet1!$A$1:$AU$20. Leaving everything EXACTLY the same (as in all headers are unchanged, the data itself unchanged), I will update the table range to Sheet1!$A$1:$AU$19 and the pivot table will go blank. Alternatively, if I copy a brand new data set into that exact range Sheet1!$A$1:$AU$20, the table will refresh perfectly with the new data.

I use a lot of templates to save time, so I can just easily copy/paste reports (again, using the same headers) + refresh the data, so this has been a huge pain. Has anyone had anything similar happen? I've gone through all of the options i can thing of to see if there's any setting that needs updating but I can't find a fix.

Thanks for your help!

]]>I've recently been upgraded to a new computer at work, which seems to have messed up my excel settings. When changing the data source anywhere outside of the existing range, the pivot table goes completely blank. For example, table range will be set to Sheet1!$A$1:$AU$20. Leaving everything EXACTLY the same (as in all headers are unchanged, the data itself unchanged), I will update the table range to Sheet1!$A$1:$AU$19 and the pivot table will go blank. Alternatively, if I copy a brand new data set into that exact range Sheet1!$A$1:$AU$20, the table will refresh perfectly with the new data.

I use a lot of templates to save time, so I can just easily copy/paste reports (again, using the same headers) + refresh the data, so this has been a huge pain. Has anyone had anything similar happen? I've gone through all of the options i can thing of to see if there's any setting that needs updating but I can't find a fix.

Thanks for your help!

hi,

I have faced a problem with agregating data in Power Query per customer and product in rows and sales in columns per rows. What I keep getting is it generates separate rows for each month per customer per product. What I would need, is to have one single row per customer per product.

I do not want to make pivot table - it has to be in excel table for some reasons.

pls find table attached

I have faced a problem with agregating data in Power Query per customer and product in rows and sales in columns per rows. What I keep getting is it generates separate rows for each month per customer per product. What I would need, is to have one single row per customer per product.

I do not want to make pivot table - it has to be in excel table for some reasons.

pls find table attached

Hi

Need help with Pivot and Charting

I have a list dates and items sold in the last 6 Months.

What is the formula to look back 30 Days and 60 Days. I want to pivot a running 30 days and 60 days how many items sold each date.

In Col D, what is the formula to look back 30 Days

in Col E, what is the formula to look back 60 Days.

Or is it easier to Pivot the Data and some how group 30 and 60 Days?

Attached is the list of items sold in the last 6 months and I also include how the graph I envision would look like

Thanks

Need help with Pivot and Charting

I have a list dates and items sold in the last 6 Months.

What is the formula to look back 30 Days and 60 Days. I want to pivot a running 30 days and 60 days how many items sold each date.

In Col D, what is the formula to look back 30 Days

in Col E, what is the formula to look back 60 Days.

Or is it easier to Pivot the Data and some how group 30 and 60 Days?

Attached is the list of items sold in the last 6 months and I also include how the graph I envision would look like

Thanks

Greetings,

I have an attached image here that I'd like to recreate. The bold polygon is the area in which my math should plot a successful answer.

1. y-axis can get any number from 1400 to 3400, but I can round to the nearest (most likely roundup) 100;

2. x-axis can be rounded to the nearest 10th (74.1, 76.4, and so on);

The idea is this is done with a calculator and a pencil, where you just point to the coordinate to see if your x-index and y-index fall inside.

The problem is (as you can see on the chart), the squares are tight. There's not much room between 76 and 77; that's fine for a pencil tip, but if I'm doing math my first reaction was I'd need about 240 columns to represent the proper x-axis values.

BUT, that makes the chart far to wide and I couldn't fit it on one sheet without massive scrolling--not pleasing to the eye, nor efficient.

QUESTION:

Much in the way a coder would make an upload "progress" bar whose length is proportional to the amount of data downloaded (as an example), is there a way to represent where (say) 76.3 would be on an upload image?

Forgive me if the language isn't clear as this its the first time I've ever entertained something like this.

As of this writing I don't have a workable .xls to upload since I keep circling back around to a brute force, caveman, method.

graph.jpg

]]>I have an attached image here that I'd like to recreate. The bold polygon is the area in which my math should plot a successful answer.

1. y-axis can get any number from 1400 to 3400, but I can round to the nearest (most likely roundup) 100;

2. x-axis can be rounded to the nearest 10th (74.1, 76.4, and so on);

The idea is this is done with a calculator and a pencil, where you just point to the coordinate to see if your x-index and y-index fall inside.

The problem is (as you can see on the chart), the squares are tight. There's not much room between 76 and 77; that's fine for a pencil tip, but if I'm doing math my first reaction was I'd need about 240 columns to represent the proper x-axis values.

BUT, that makes the chart far to wide and I couldn't fit it on one sheet without massive scrolling--not pleasing to the eye, nor efficient.

QUESTION:

Much in the way a coder would make an upload "progress" bar whose length is proportional to the amount of data downloaded (as an example), is there a way to represent where (say) 76.3 would be on an upload image?

Forgive me if the language isn't clear as this its the first time I've ever entertained something like this.

As of this writing I don't have a workable .xls to upload since I keep circling back around to a brute force, caveman, method.

graph.jpg

Hello!

**Problem: ** I needed to create many pivot tables looking at the same data source, but then when I wanted to group different dates within that source data. I found that I was having multiple group filters (group1, group2, group3 etc. show up in my field list of other pivot tables that were often copied and pasted versions of the former pivot tables with one small tweak). By Googling, I realized I needed to create new pivots in a helper spreadsheet to get around this grouping issue, to do the grouping there in the helper spreadsheet, and then paste that back into my spreadsheet with all of my other pivot tables. This apparently forces Excel to create a new pivot cache. I have to pull in new data manually from another source to update the source data and refresh all pivots.

**Question:**: After I download and paste the new data into the data source table for all my pivots, will those without the shared data caches update when I do a refresh all for my pivots?

**Version:** MS Office 365 ProPlus

]]>Hello All

Please see attached

I would like a 2nd graph showing (Pie Chart) showing % of sales for each customer

I would like this on 1 Tab so they both update as more data is fed into the sheet

Thanks for your time

Please see attached

I would like a 2nd graph showing (Pie Chart) showing % of sales for each customer

I would like this on 1 Tab so they both update as more data is fed into the sheet

Thanks for your time

Hi,

Dear expert's is there any way to calculte no of days remaining for each cell from a range.

I want pivot to calculate no of remaining days from each columns.

Finish

A 5-Mar

B 20-Jun

C 15-Sep

D 21-Oct

]]>Dear expert's is there any way to calculte no of days remaining for each cell from a range.

I want pivot to calculate no of remaining days from each columns.

Finish

A 5-Mar

B 20-Jun

C 15-Sep

D 21-Oct

HI All,

Just want to check if anyone can help me come up with the best chart/s i can use for the raw data below:

Capture.PNG

So I have the categories section and sub categories. What i need to do is to show in Graph to show if we are aligned in the project for this 2020.

You can see the "as of today status" meaning thats the latest update/ numbers or percentage I have got.

Need to show many percent of numbers left to achieve the 2020 target.

Sorry new to excel graphs.

Appreciate all the help I can get.

Just want to check if anyone can help me come up with the best chart/s i can use for the raw data below:

Capture.PNG

So I have the categories section and sub categories. What i need to do is to show in Graph to show if we are aligned in the project for this 2020.

You can see the "as of today status" meaning thats the latest update/ numbers or percentage I have got.

Need to show many percent of numbers left to achieve the 2020 target.

Sorry new to excel graphs.

Appreciate all the help I can get.