chart 2016

I have 2 columns of data in Excel 2016. Col. A is a list of states and Col. B is a percentage. I've successfully made a clustered bar chart (vertically oriented list of bars) with A as the Y axis and B as the X axis. Now I'd like to add a vertical line showing the median. I've been trying to...

Hello to eveyone I want to get a pivot chart from a table that the horizontal axis has subcategory and I really dont have an idea how can I make that how ever I can not specify categories to special axis ABCD1basement poylgonstarget ratiodisplacement(cm)Initial...

Hi I'm trying to make a chart using named ranges, and when I try to add a series, I get the error 'Reference is not valid. Reference must be to an open worksheet.' I have searched the problem and done everything suggested: - I am typing it in correctly - All named ranged are within the...

Hi I created a Treemapchart using excel 2016 I am trying to copy & paste the chart into a word document using the link data option however the option is not available. I want to link the chart to the word document so it automatically updates whenever I change the source data in excel. Thanks

Hello everyone, I'm working with a line chart that (dates on the X axis and some series of data in the Y axis), when i add new columns of data (new dates with data), the x axis extends, but the chart area does not "adapt" to it, so the new part of the chart with the new data doesn't "fit" the...

Hello all - I am a bit stick here, and could use a little push in the right direction, please: Column A has numeric data Column B has a running total of the data in A (and there are a number of other columns…) I have a line chart that depicts the curve of Column B, ie, a line chart of the...

Hello I have an Access Db to export a query and create a chart based in worksheet ranges (B2 to last value down) and (C2 to last value down). My command button my code creates a chart with primary and secondary axes values. This is my code working well: Sub cmdTransfer_Click() Dim sExcelWB As...

Hello, I have a workbook that has a lot of charts (over 300 on 2 sheets). What I am after if possible, is to list each chart on each sheet and it's location (cell reference). Sheet one is called: Chart_Tables Sheet two is called: Remote_Chart_Tables Worksheet name where they are to be...

Example: I have 3 columns. Col 1 is dates. Col 2 is numbers. Col 3 contains a 'A' or 'B' in each cell. So normally I select Col 1 and Col 2 for a chart and all good. But how do I select cells from Col 2 ONLY when an adjacent cell in Col 3 contains a 'B'? Thanks PS I do not mean manual...

Hi! I want to make sunburst chart for my company showing, an annual cycle. The cycle will show month, week, day and what action to take. I have made an excel sheet wich contains my data, see enclosed picture. <tbody> Month Week Weekday Activity Januar Uke 1 Man Vareopptelling Tir...

Hello I have this chart / graph from here : https://www.officetimeline.com/excel-timeline It has to be a dynamic so i have to make a macro searching for the specific ranges. The problems is at the "6.Add titles to your timeline's milestones" (Part B and C) category where when i try to update...