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...
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...
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...
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...
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:
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 =...
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...
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...
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
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...
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...
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
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...
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...
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...
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...
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...
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!
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 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.