graph

I want to create a Line chart that doesn't graph 0 values. I know there are methods to change the data to be able to graph 0s but I can't do that for a variety of reasons. Is there anyway of not graphing the zeros? Or replace all the 0 values in an array of arrays that represent my data? I'd...

I have a graph of calls for each month. Jan to Dec Along the year, say in June, I'd have blanks for July to Dec. I'd like the graph to only show months with data, ie Jan to Jun. and not include empty space for the last 6 months. I've searched and found how to exclude blank dates between...

In desktop version we are using the camera tool to show a graph that the user pasts into a different worksheet. When we put this file in excel online this function is not available and the user can not paste the graph from the downloaded excel to excel online. Does anyone have any ideas of how...

Hi all I managed to create a macro to build a graph which updates each time the lenght of the columns change. When I try to put the name of the horizontal axis, it work. When I try to do the same with the vertical axis it doesn't. Anyone willing to help? I am very grateful Thanks a lot valentina

Hi, I'd like to be able to plot multiple data series on the same graph with the same horizontal axis. I have sets of data including metrics like temperature, pressure, distance, height, speed etc etc all of which have the same horizontal axis (time). The problem is that all of the metrics...

Hi; I did see this question asked before, but I couldn't find a thread with a posted answer. I'm mostly frustrated because I'm 90% sure it's a stupid simple fix, but I can't seem to get it... I'm trying to copy a graph format from previous reports so that it's consistent. I've got a stacked...

Good morning, hopefully this is an easy fix. I have a graph that displays the axis on the screen slanted but when I print it, it prints straight. I have another graph on the same page that prints and displays slanted correctly. Anybody has any ideas on how to fix this? Thank you!

Hey Guys How do I add a Graph by using VBA, and add the data on my own, also through vba? thanks in advance! :)

Hello, I've really tried to figure this out by googling and struggling. I have a database of drivers which is in order of week number 1 - 52 along the top and their MPG (miles per gallon) per week. (as below). I wondered is it possible to put this into a graph, ideally or some kind of table...

Hello MrExcel Members, I need to first ascertain how many digits are to the left of the decimal point and then use that data to fill in a multiplier for use in a formula. Following is the data on a worksheet that produces a speedometer graph: Columns "A" & "B" Performance Label Value Poor...

hello, i'm trying to pull specific data from a column for a graph. this column has cells that have dates in the in format dd/mm/yyyy, but also has cells with the word 'pending' in it. i want to make a chart that includes the cells with a date value (and will be pulling in corresponding data to...

I have a simple horizontal bar graph. The X-Axis title currently sits on the X-Axis at the top of the graph (above the horizontal bars). How do I move the X-Axis title to the bottom of the graph along the x-axis (below the horizontal bars)? I know I can physically drag it, but is there an...

I have this code that generates a graph. I would like to display the graph in a userform. I'm getting an error and I'm not sure why. Please help. Thanks Sub MyCandlestick()Dim OHLCChart As ChartObject Dim LRow As Long Dim ChartName As String, fname As String LRow = Range("AA" &...

I have a scatter chart that I want to change based on the Table heading chosen in a Drop down Box. I have followed all the posts suggesting using name ranges but nothing seems to be working. This is what I have so far: <tbody> <colgroup><col><col><col></colgroup><tbody> GRAPH X SERIES (INF)...

Hi all, I'm relatively new to Power Bi and I looked at a couple of questions on the forum, but I couldn't find the right answer. I hope some of you could help me. I have a field which included a StartDate and a field with an EndDate. Between those dates, certain units should be built (let's...

Hi all, I have a graph that links to a pivot table. The graph shows data from students. We have 225 students. Is there a way of printing the individual graphs for each student automatically without having to change the filter each time and pressing print 225 times? Many thanks in advance! Russ

Hello All, I'm wanting to create a line graph which show a cumulative forecasted value of spend of time (simple enough!). However, I want to include independent cumulative value of year end budgets where lines plot back to both axis (e.g. Year 1 (x) and £1m (y). The idea is that the graph will...

Hello, I have a spreadsheet, on the first tab is a large amount ofaccounts showing existing and new sales. Each account has also has a separate tab within the samespreadsheet. Where data (existing sales and new sales) is available onthe first tab, I would like a graph to automatically...

I added a trendline to a graph. How does excel figure out the trend?

Hi I have created a pivot Graph using data from a table However i would like to make a few copies of the Pivot chart graph i have created and set it up so it shows different outputs using the same data. E.G - The graph i currently have created is a stacked bar graphs which shows the split by...