chart

  1. B

    Excel Visual Chart

    Hi, I'm looking for help designing a chart to show a sales chart along different data sets. I want the chart to show Sales, Profits, from two different revenue stream and for each time period. How can I design a chart to show all the data in one chart? Item Sales Profits Sales Profits...
  2. A

    Gauge Chart

    I'm trying to create a gauge chart in which the colors of the gauge are equal 45 of the 180 half circle as picture below but the values for each section are much different. See the chart to see which values would fit into each section of the chart. Is this even possible? Any help would be much...
  3. R

    Lines on graph updates but x axis doesn't

    I have an excel file containing share prices, and graphs to show how the shar price moves each month. When I drag down the data for the date and share prices for the last 30 days, it updates the line on the graph to show the movement, but the date on the x axis doesn't change. So last month, I...
  4. R

    Excel Pie Chart Formatting Inquiry - Trying To Remove Gray Line Within Pie Chart

    I'm building Pie Charts for a client at work and they are asking me to try and remove the Gray Line that goes through the middle of my Pie Charts. I've included the data set for reference. As you can see, only the 'Lab' User Group has any value in the SF column. Despite only the 'Lab' User...
  5. K

    Create Excel chart with specific data

    I created a chart in excel , the chart would be perfect, but the date values in the table are missing from the X axis, I don't know much about how to create charts just the basics, could you help me? My Chart: All Data:
  6. T

    VBA code to change chart type and axis for 2 series

    I am trying to change the chart type for 2 series. Series 1 should be a Column chart with the primary axis and Series 2 should be a Line Chart with the Secondary axis. I get a 438 error. WHat am I doing wrong. Please help. I am using Excel 2016 Sub Chart1_Update() Set wsPivotChart =...
  7. T

    Word Crash, paste fail and colour loss during VBA Macro when Pasting Image from Excel

    This code is driving me insane. I have created a macro that is structured as below. It creates a chart based, copies it from an Excel Chart tab and pastespecials it into word. Creates a page break, clears the clipboard and does it again for a total of around 100 times. Please see the below...
  8. A

    VBA to colour line chart based on cells colour

    Hello, I have about 20 line charts with >30 series in each one which I want to colour based on cells in one of tabs, like this: So I am trying to use VBA to pick up the line and marker properties for each of the series above, but for the life of me I can't find a way to make it go from...
  9. S

    Change Trendline on Excel Chart

    Hey, Is there a way to change the trendline in the attached Sleep view, so that it looks a lot sharper & trend is clearer over the 30+ days. Kind of like in the attached CPU view? Thanks
  10. P

    Add 'Window' (?) To Line Chart

    I'm trying to add a window (if that's even the right term) to a line chart. I've done a mockup attached - it's just a line chart with a yellow rectangle drawn over it. Is there a way to actually add this rectangle as part of the chart and make it dynamic based on cell values? I want it to...
  11. T

    Circle chart showing times of the day

    Hi all, so my problem is this. I want to basically make the attached picture in excel. What this shows is a 24 hour day, divided into various chunks of X hours. This I can kind of do with a multiple-series donut chart (I need multiple concentric wedges), however the bands are WAY too thin and...
  12. G

    Dynamically changing a chart dataset based on dropdown value

    Hi, I have a chart which fetches its data from a dataset. on the sheet i also have a dropdown list with values in it. I want the chart to use a different data set based on the value of the dropdown list. is this possible? thanks Gareth
  13. M

    Combo Chart - linking data to different data points

    I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...
  14. L

    Chart: 2 columns of x-axis values and y-axis values but want one series

    Hi, I am trying to make an line/scatter line chart for trend analysis where there are x-axis and y-axis values in two different columns. In the attached image, I would like to use columns D and I as x-values and E and J as y-values. However, I want the points to display in order of the x axis...
  15. M

    Line graph - change colour if number decreases

    Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...
  16. T

    Converting Sparkline from Google Sheets to Excel

    I have a google sheet that uses the sparkline formula '=sparkline(C6:C)' which seems to automatically add to the sparkline with new incoming data in the C column. However, this data range is not valid in Excel when trying to create a sparkline. Does anyone know how to replicate this to have it...
  17. G

    Pivot Table and Chart using same Query/Slicers/Timeline but different groupings

    Hi All, can't seem to find a solution to my problem. I have written a query that returns data from a database that is viewed in a pivot table. I use timelines and slicers to change what I am looking at, this works fine for one table and chart. I want to create other tables and charts also linked...
  18. R

    Chart not showing progress bar match with percentage

    Can someone please help me understand why the data bar in the second chart (screenshot attached) isn't showing the bar height relative to the percentage like the top one. Tried every setting I came across and it won't show the bar correctly. Thanks in advance!
  19. J

    VBA to change chart background picture offset values

    Hi, I'm looking for a way to change the Offset Top, Bottom, Left and Right values through VBA. The chart is an XY scatter plot. Any help appreciated!
  20. N

    Inspiration needed.... Excel chart visual aid

    Hi, Im looking for some inspiration. I have a table / spreadsheet that I need to create charts or other forms of vision in order to drive focus to the areas which need it most. Using the sheet: Excel File The sheet is basically looking at 7 machines, R1, R2 etc... Looking at R1 as an example...

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