graphs

Hi there, I'm producing some graphs based on a set of questionnaires. Some are Likert Scale statements and some are simple yes/no/don't know questions. We are trying to split the answers down by type of respondents: Amenity manager; productive managers; multi-functional managers; and...

How can I graph two lines of data into bars that share the same x axis, but different Y axes and are not stacked. The alternate is to make one of them a line graph, but in the case I need them both as independent bar graphs next to each other and referencing different y axes. Thanks in advance...

I'm working on a spreadsheet that will chart data monthly. I want to give each month it's own tab. I've set up a tab (Current Month) that shows data on - you guessed it! - the current month's data, using the Today() function in A1 for the sheet to determine the current month. I created all my...

If I want to have the same color following a for example a "brand" in a graph. Excel automatic set colours depending on the value, but if I for ex in my graphs always want that AUDI to displayed in RED and BMW displayed as BLUE. What function must I use ?

Are there any sale dashboard templates people use that they could share? Particularly interested in Speedometer Radial type graphs. I.e green is good, yellow ok and red is bad.

Hi, I have the following information: X Axis: Product (Tomato, Apple, Orange, etc) Y Axis: Date range (Sept 1-Sept 30, Oct 1-Oct 31, etc) Values: $ made on each product I want to create a simple chart that will update information based on a drop down menu selected on another sheet. For this...

Hello All, I am running a macro that grabs data(array of data and a graph of this data) from a workbook and enters into another workbook. However the graph keeps the old series links (this data is changed daily so changes the graphs in new wokbooks) is there an easy way to make it so the seris...

I need to create a graph just like the one shown in the picture i attached. it does not need to have the curve, rectangular bars would be fine. but the axis should be the same. I cant figure out how to make it in excel. If someone can explain, it will be helpful. Thanks (link to sample data in...

Hello, I have a workbook that I use for "Performance" tracking of our machines. I currently have multiple worksheets in this workbook. I have tab for graphs with 15 different graphs on each tab. That is 120 graphs, these graphs update automatically when data is entered using "Name Manger" with...

Hi All, I am new here and I was hoping to get help with my problem as I am at the end of my limited powers. I have 2 Excel Workbooks online for clients to look at. One is "parent" WB (dashboard with graphs) the other one is "Data Input" WB (all information for graphs for dashboard are updated...

Hi Everyone, Could you let me know a formula which would show me a full total sales performance for the month. Eg : Date no of sales total sales 1 10 2 15 3 00 4 00 5 20 6 30 7 0 8 10 9...

Hello, Hoping someone can help me with this dilemma. I have an annual project that needs to have 19 graphs updated with new information. This graph will keep the original data from the start date, but it will need to add on new data each year added into the graph. I'm hoping I can macro this...

Hi Guys, I've been having issues with charts on Excel 2016 I have 5 different worksheets with calculations on them, each sheet has cells in identical positions, the only difference being the input values for the calculations. I need 8 graphs per worksheet (5x8 is a lot of graphs!) I've...

Hello All, I am an VBA noob looking for help from the experts here. Essentially what I am trying to do here is: I have an Excel workbook with multiple sheets, some of those sheets have graphs in them, some sheets have 3-6 graphs in them. What I want to do via vba code is: go through all of...

I have a sheet in a workbook that includes a bunch of graphs (as objects, I guess). I want to create multiple copies of the same sheet to facilitate my project, but when I make a "COPY" of the sheet, the graphs do not show up on the new sheet. Thanks, J

Hi I have a sheet with 20 graphs that gets its data from another sheet , Is there a way of changing the source sheet ie I have up to 10 sets of data on separate worksheets all with the same data just from different depts . What I would like is one set of graphs but be able to choose which...

Good morning Everyone, I'm hoping someone might know the solution to fixing this problem. I've created a Chart with only 2 Series. When they're both on the same axis it looks fine as any graph does, however i want to move one Series to the secondary axis. When i do this, the Bars in the graph...

I have a workbook with four sheets of income scenarios. i wish to create a graph that will show me what year the income break even point is. The other data i have for each income scenario is cumulative savings. I think i need 2 graphs one that show income by year for four different income...

I have a project here where I receive large data files in Excel. I have to sort these and produce graphs, showing trends over time etc. The data I receive is "scrambled" in the sense that it is data for several different "profiles" at once, and I first have to manually sort each of these...

Hi Everyone, I have few tabs in an Excel Sheet with set of data and few graphs. Most of these data and graphs are monthly sales figures formatted on tables to show some trends and percentages. Each month I need to copy some of these tables and graphs into PowerPoint slides. I heard there...