Hi,

I was wondering if someone could help me with the attached spreadsheet. What I'm trying to achieve is to add a budget line into the graph so it tracks both sales and budget figures. The data for this information is pull from the 2nd Sheet named "Gross Sales"

Any help would be much appreciated.

I was wondering if someone could help me with the attached spreadsheet. What I'm trying to achieve is to add a budget line into the graph so it tracks both sales and budget figures. The data for this information is pull from the 2nd Sheet named "Gross Sales"

Any help would be much appreciated.

I am trying to make calculations on a data table that is on a shared worksheet with multiple pivot tables but, even though the cells are formatted correctly and the formulas are correct, I have to go in and edit each cell ("F2"/"ENTER") every time I want the table to recalculate.. I have tried everything I can think of to fix the issue...

Hi All, I have a very large data set of survey responses. We report the result as a rolling 3 month period that increases at a 1 month interval.

For example:

Jan - Mar

Feb - Apr

Mar - May

Apr - Jun

May - Jul and so on....

At the moment I use a pivot table to get the monthly result. I then have to select the 3 month period I want and add it to a separate table, I then have a chart based on the table data. Is there a formula that I can add to the raw data that would automatically update the date ranges so I can plot a chart directly from the pivot table?

PS: I've never used VBA before... Hope this makes sense!

]]>For example:

Jan - Mar

Feb - Apr

Mar - May

Apr - Jun

May - Jul and so on....

At the moment I use a pivot table to get the monthly result. I then have to select the 3 month period I want and add it to a separate table, I then have a chart based on the table data. Is there a formula that I can add to the raw data that would automatically update the date ranges so I can plot a chart directly from the pivot table?

PS: I've never used VBA before... Hope this makes sense!

Hai!

The problem is that I have a number of x values and it's expands graphic. So maybe there is opportunity calculate out the avarage value and make single-line graphics.

Capture.PNG

]]>The problem is that I have a number of x values and it's expands graphic. So maybe there is opportunity calculate out the avarage value and make single-line graphics.

Capture.PNG

Hi

I want to plot multiple data sets in one graph as a function of time. Each data set has been logged with a different time interval and at different times overlapping each other. If I try to plot them in the same chart, excel will simply count the number of data sets and plot them with the same spacing. But this approach cannot be used since some of my equipment logs every 40 seconds and some logs every 5 minutes. This means that one data set will consist of about 7.5 times as many points as the other within the same time.

Can excel plot my data with different spacing along the x-axis so each measurement fits correctly according to time?

I want to plot multiple data sets in one graph as a function of time. Each data set has been logged with a different time interval and at different times overlapping each other. If I try to plot them in the same chart, excel will simply count the number of data sets and plot them with the same spacing. But this approach cannot be used since some of my equipment logs every 40 seconds and some logs every 5 minutes. This means that one data set will consist of about 7.5 times as many points as the other within the same time.

Can excel plot my data with different spacing along the x-axis so each measurement fits correctly according to time?

Hi,

I am completely new to charts in excel.

I have attached a file as example. I have made a chart myself in example to show what I want to achieve, and a brief explanation text. Example only shows plot for category A, but I want all categories in legend and chart.

What I want to do is to plot time(x-axis) vs level(y-axis) for each category. There will be two measure points for each category and I would like to have category as a legend. Shape of each point should be different for each category.

Really appreciate some help :)

I am completely new to charts in excel.

I have attached a file as example. I have made a chart myself in example to show what I want to achieve, and a brief explanation text. Example only shows plot for category A, but I want all categories in legend and chart.

What I want to do is to plot time(x-axis) vs level(y-axis) for each category. There will be two measure points for each category and I would like to have category as a legend. Shape of each point should be different for each category.

Really appreciate some help :)

I have created a Exchange Rate Chart. And there is a option to select to see the flow for 1 week ago, 1 month ago, 1 year ago and 2 year ago (Period). The main data table is last updated at 05/03/2017 and i have created another tab which will generate the list of rate when the Currency and Period is chosen. Hence i use a Name to define the Data Range (in my excel, its call Chart2). WHen i set my Data Range to Chart2, it work perfectly in my PC. However, when i send to other people. Somehow, the Chart2 don't seems to automatically update unless the person manually key in Chart2 into the Data Range. And even so, when that person, click on a different period. The Data Range go wrong again.

I have attached the sample. Can anyone tell me whats wrong with it? Or is there any way to Generate the Chart right from the Main Data Table?

I have attached the sample. Can anyone tell me whats wrong with it? Or is there any way to Generate the Chart right from the Main Data Table?

My pivot table has 3 columns Name, FTE, and Base pay. I want to first sort my pivot table by Base pay from Largest to smallest and then sort by FTE from Largest to smallest. Base pay contains a persons annual Pay and I sort this one so that the Person who heads up an area is on top and the ranking follows the FTE shows either a 1 or a 0. I then want all FTE's that are zero at the bottom of the list while still maintaining the rank structure by pay. ive sorted by base first and then FTE and when I sort the FTE it moves the base pay around and I can't figure out how to maintain my first sort when sorting the second one. I have tried right clicking on a zero and moving to end but that also moves everything around.

]]>Hmm, I´m stumped.

Im trying to create a chart based on the following data:

Monkey 5

Bear 5

Monkey 2

Monkey 4

Bear 3

Dog 7

I want the chart looking something like this:

chart.GIF

Any ideas how to do this? Im using excel 2016.

Regards

Mattias

]]>Im trying to create a chart based on the following data:

Monkey 5

Bear 5

Monkey 2

Monkey 4

Bear 3

Dog 7

I want the chart looking something like this:

chart.GIF

Any ideas how to do this? Im using excel 2016.

Regards

Mattias

Hi,

I have a line/bar graph with an X-axis made up of 2 different columns - a "date" and a "type". This makes it easy for me to tell what type the bars and lines correspond to, which is great. However, I wish to format the axis as a date so that the data points are proportional to the date on the axis. I'm unable to do so as this option is greyed out.

If I remove the "type" column from the chart data area, then it automatically recognizes the dates and plots the data points proportionally on the axis. However, it also includes fills in the axis with dates that are not in my data. My x-axis consists of discrete events that I wish to plot rather than a continuous one.

How can I do this?

]]>I have a line/bar graph with an X-axis made up of 2 different columns - a "date" and a "type". This makes it easy for me to tell what type the bars and lines correspond to, which is great. However, I wish to format the axis as a date so that the data points are proportional to the date on the axis. I'm unable to do so as this option is greyed out.

If I remove the "type" column from the chart data area, then it automatically recognizes the dates and plots the data points proportionally on the axis. However, it also includes fills in the axis with dates that are not in my data. My x-axis consists of discrete events that I wish to plot rather than a continuous one.

How can I do this?

Hi there,

I am new in here so I am sorry for any mistake.

I have table in an excel spreadsheet that I would like to take some informations to the other sheet.

I am not sure if I could upload the sample file ,so I did summarize my excel table above. IF I could manage the upload , please take a look at it

In the table;

Bcoloumn is "Country" H "products interested"

C is "adress" I "notes"

D is "firm" J "action"

E is "telephone number"

F is "e-mail"

G "scope of activity" ,

SO here the question.. I would like to take "country" "firm" "e-mail" sections to the other sheet IF ACTION PART IS "MAIL SENT" !!

And I am assuming that I could solve this with Pivot table so thats why the title is Pivot .

Many thanks!!

I am new in here so I am sorry for any mistake.

I have table in an excel spreadsheet that I would like to take some informations to the other sheet.

I am not sure if I could upload the sample file ,so I did summarize my excel table above. IF I could manage the upload , please take a look at it

In the table;

Bcoloumn is "Country" H "products interested"

C is "adress" I "notes"

D is "firm" J "action"

E is "telephone number"

F is "e-mail"

G "scope of activity" ,

SO here the question.. I would like to take "country" "firm" "e-mail" sections to the other sheet IF ACTION PART IS "MAIL SENT" !!

And I am assuming that I could solve this with Pivot table so thats why the title is Pivot .

Many thanks!!

chart.png

I cannot seem to figure out what needs to be selected to make the chart properly place the data labels?

]]>I cannot seem to figure out what needs to be selected to make the chart properly place the data labels?

Hi All,

I'm looking to build what I thought would be a rather simple dynamic chart that adds variables as rows of data are added to excel (with multiple not-changing columns). I feel as though I've done something similar before, but can't seem to get it to work based on the dynamic range tutorials I've followed via google searches (using basic offset formulas and defined named ranges). I'm not sure if it's because I have my data laid out incorrectly (and should flip-flop the X and Y axis), but please let me know if you have any thoughts.

I've attached a very simple excel template that shows how my data is laid out and how I'd like the line chart to look. Ultimately, the "year headers" will remain the same (2017-2021) and there will be no additional columns added (should act as the X Axis). However, I do have some dynamic formulas that will add rows/countries (ex: Chicago and Barcelona) depending on what a user selects in another part of the sheet. The formulas in these cells either returns (ex: B6, B7, B8, B9, etc) a blank or a city.

I'm hoping to be able to have the Line chart add/remove cities based on user input. It sounds easy and I thought I'd have this settled in a matter of minutes, but I can't seem to figure out how to accomplish this.

Let me know if you have any questions. Thanks!

I'm looking to build what I thought would be a rather simple dynamic chart that adds variables as rows of data are added to excel (with multiple not-changing columns). I feel as though I've done something similar before, but can't seem to get it to work based on the dynamic range tutorials I've followed via google searches (using basic offset formulas and defined named ranges). I'm not sure if it's because I have my data laid out incorrectly (and should flip-flop the X and Y axis), but please let me know if you have any thoughts.

I've attached a very simple excel template that shows how my data is laid out and how I'd like the line chart to look. Ultimately, the "year headers" will remain the same (2017-2021) and there will be no additional columns added (should act as the X Axis). However, I do have some dynamic formulas that will add rows/countries (ex: Chicago and Barcelona) depending on what a user selects in another part of the sheet. The formulas in these cells either returns (ex: B6, B7, B8, B9, etc) a blank or a city.

I'm hoping to be able to have the Line chart add/remove cities based on user input. It sounds easy and I thought I'd have this settled in a matter of minutes, but I can't seem to figure out how to accomplish this.

Let me know if you have any questions. Thanks!

I have a table that looks like this:

**ID VALUE1 VALUE2 VALUE3 VALUE4**

1 TEST1 TEST2 TEST3 TEST4

2 TEST1 TEST2 TEST5 TEST6

This is a table populated by user data. I then want to organize the table so that the different TEST# shows the different ID's.

For instance, if I filter on TEST1 I would like to get ID 1 and 2. If I filter on TEST5 I would like to get ID2. How do I solve this? Anyone :)

]]>1 TEST1 TEST2 TEST3 TEST4

2 TEST1 TEST2 TEST5 TEST6

This is a table populated by user data. I then want to organize the table so that the different TEST# shows the different ID's.

For instance, if I filter on TEST1 I would like to get ID 1 and 2. If I filter on TEST5 I would like to get ID2. How do I solve this? Anyone :)

Hi All,

Very little experience with graphs so hopefully this should be an easy one...

With reference to the attached example, I have four data series that I want to present on a Combo chart. The first two series detail the number of units sold to two different customers. I want this data to be presented as a stacked bar on the graph. To give an example, if I have one customer who I've sold 10 units to, and a second customer that I've sold 100 units to, I want the bar to protrude from the x axis to the value of 110 (total units) on the y axis however, the bar shall be split into two sections; the first section will represent the lower of the number of units sold to each customers (in this case we sold ten units to customer A and 100 units to customer B so the first section of the chart shall protrude from the x axis up to the value of 10 on the y axis; the second section of the bar will begin at the value of 10 on the y axis and continue to the value of 110 on the y axis). Each section needs to be a different colour, ideally yellow and blue respectively.

The latter two data series detail revenue derived from the largest client, and total revenue in the same periods. I want revenue to show as a line.

Kindly provide instructions on how to do this because, as you've probably surmised, the attached isn't my real life example and I will need to replicate the process for my actual data.

Very little experience with graphs so hopefully this should be an easy one...

With reference to the attached example, I have four data series that I want to present on a Combo chart. The first two series detail the number of units sold to two different customers. I want this data to be presented as a stacked bar on the graph. To give an example, if I have one customer who I've sold 10 units to, and a second customer that I've sold 100 units to, I want the bar to protrude from the x axis to the value of 110 (total units) on the y axis however, the bar shall be split into two sections; the first section will represent the lower of the number of units sold to each customers (in this case we sold ten units to customer A and 100 units to customer B so the first section of the chart shall protrude from the x axis up to the value of 10 on the y axis; the second section of the bar will begin at the value of 10 on the y axis and continue to the value of 110 on the y axis). Each section needs to be a different colour, ideally yellow and blue respectively.

The latter two data series detail revenue derived from the largest client, and total revenue in the same periods. I want revenue to show as a line.

Kindly provide instructions on how to do this because, as you've probably surmised, the attached isn't my real life example and I will need to replicate the process for my actual data.