# charting

1. ### dynamic charts with missing data in chart range

Hello So, I'm working with a raw data set that I have made, and I frequently update the data whenever I collect data from sources. The first two rows of the data set are frozen, so I can have some semblance of what my data titles are. Using the data, I have made several charts. Now, I know I...
2. ### Charting issues

Hi. there are lots of videos online teaching gantt chart with scheduling (by hours and minutes). but I haven't found anything about inserting break hour (lunch hour) Is this doable? can anyone guide me where to find it? Thanks
3. ### Using the cell that is selected for the value in a formula

Hi all, I am wondering if something is possible at all. I have a calendar on Excel (month-by-month) and then another sheet with all the dates of all the different events that are happening. I want to be able to click on a date in the calendar and then below, a list of the events that are...
4. ### Float Chart on a spreadsheet

I’ve created an Excel workbook that tracks blood pressures and heart rate. The table progresses down the sheet allowing for consecutive entries. Then, I have included a column chart for a visual reference. Though I couldn’t show it here, the chart actually is positioned with the upper left of...
5. ### Charting with Trend Line

I have a question on charting in Excel. I have a spreadsheet tracking investments over the past few years. I include a “Trend Line” in the chart via a polynomial regression. However, I’m confused on the “order” of the trend line. It allows values 2-6. It appears 2 is the most linear with...
6. ### Copy paste charts with dynamic rows/column references

Hey guys, Not sure if I neeed VBA to accomplish this or not, but I can’t be the first that needs a way to do this. I have a column of dates in A. In column B I am computing the AVERAGE of the values in columns C through Z). And then in columns C through Z I have data. I would like an easy way...
7. ### How can I chart this data

Hey guys, I am having a little trouble working out how i can chart this data. Basically, i am wanting to see a timeline with runtimes for each of these file creations. I was thinking if there was some way to just have each line as an individual start..stop, with a connecting line, at the...
8. ### Interactive charting with filters

Hi guys, new to the site so let me know if I'm doing anything wrong and I'll improve! So I have a large chart of data with tens of thousands of cells. My task is to create a tool that will create a dynamic and interactive column chart that is linked to either drop down boxes or a search bar...
9. ### Changing direction the arrow points when I draw it in with VBA.

Hello, I am using VBA to animate movement between two points on a graph. I am also drawing an arrow to illustrate the movement. This macro works fine... I used the recorder for it, so there is probably some stuff to tidy. My concern is that it is drawing the arrow pointed the opposite...
10. ### New to using excels charts

I am new to using excel for charting. I was asked to prepare charts or tables that will effectively answer the following questions: Of the subsectors noted in the table, which produced the highest number of fatal claims in 1990 – 2014 for: · Pneumoconiosis (make sure to include...
11. ### Can I use both vertical and horizontal formulas

Hey Gang, I am attempting to create a dynamic chart where info hides or appears using a checkbox. I have been able to make it happen for EITHER the vertical OR the horizontal, but cannot figure out how to do both. In other words, I have multiple individuals on the vertical plane and multiple...
12. ### Excel does not remember the correct color of inverted bar chart

Hello, I am creating a dashboard with a few bar charts, where the negative values have a different color then the positive values. To achieve this, I use the option "invert if negative" in the fill properties of the chart. The problem is that when I save and re-open the file, the red color of...
13. ### Intern Help: Charting & Delineation

Hey guys and gals - Long time lurker here finally posting as I've been given quite the Excel challenge for my first week of an internship. First things first, I'm using Windows 8 and Excel 2013. Alright, so here's my dilemma: The company I'm interning with sells compressors that come in...
14. ### Automating good data labels on stacked area pivot

I have a stacked area showing resource use across time. Each resource is categorized by: Chemical ChemA, ChemB, ChemC etc. (values change by month) Cost cheap/expensive (does not change by month per chemical) Region AUS/EU/NA (does not change by month per chemical) I slice/pivot the data so...
15. ### Multi variable charting

I have a sheet of information that I would like to graph. See the sample below. You can see that there are results for different locations, different dates. There are very few common dates. I need the ability to create either a stacked bar of the 10 variables, a bar chart of the total, a line...
16. ### 2003 charting - not allowing for multiple vertical axis option

Howdy, I am trying to produce a chart including two columns of data and a column including corresponding dates. I am only able to view one column of data in the chart and excel is not giving me the option of plotting on a secondary axis. Why am I not being given the option to view data on a...
17. ### Plotting Chart data Accurately

I have several columns of stock data including the date. All data for all dates that are not high or low for a given period have been removed. I wish to plot this zig zag line that alternates between the last top and the next bottom on a pre existing chart that contains all of the historical...
18. ### Export charts and name the file by the charts title

Hi all, I was wondering if someone knows how to do the following, or can refer to an implementation of such a thing. I have an excel file with many sheets and charts scattered in the various sheets. I'd like to export all charts to a folder as image files. I'd like the file names to be...
19. ### Can I create multiple graphs into one chart? (example provided)

Hello all, I have a table with 3 sales metrics (one for each of 3 regions) across the months of the year. The horizontal and vertical axis should be identical for all three. What I'd like to do is to plot all three, stacked one on top of another, in one single graph, automatically. I attach an...
20. ### Line chart with multiple frequencies and shading during certain time periods

I would like to be able to create a time series line chart that has data appearing at different frequencies and that has shaded regions representing economic recessions. The typical approach for creating recession bars is described here. The standard approach described in the link works fine...

### 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.

### Which adblocker are you using?

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

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