graph

  1. D

    Excel Online

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

    MACRO to build a graph - y axis not shown

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

    Advanced Graph options.

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

    Stop overlapping of stacked columns in chart (Excel 365)

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

    Graph not displaying the same in print preview

    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!
  6. 8

    VBA Graph

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

    Graph for multiple staff by week number

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

    Check number of digits left of the decimal point

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

    specific formula for chart data

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

    Excel Graphing Question - Move X-Axis Title

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

    Display Graph in Userform

    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" &...
  12. J

    Dynamic Data Series Scatter Chart

    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)...
  13. N

    Unit count between Start- & EndDates

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

    Pivot table/graph - mass printing

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

    Independent Targets in Line Graph

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

    Display Graph if data available only

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

    Trendline formula

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

    Multiple graphs from 1 pivot Table

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

    Macro to add Series on Graph

    I am trying to automatically add series using VBA. I have a list of values that I want to graph and I want to see if I can automatically do it based on different values. My graph would be column K as the x-axis; column J as the y-axis and column B as my series names and pulling data from them...
  20. J

    Trying to get a compliance formula based on content of a vlookup list.

    Hi all, I am slowly getting through a spreadsheet I am trying to make to show requirements for training, date taken, then highlight when it becomes due, or overdue. This will then allow you to email a copy of the sheet, or drop a graph straight into powerpoint for you. Most of it is done now, I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top