plot

Hello, I am having trouble creating a code that would allow a user to pick which column(based on names in cells A1-D1) to use as x axis to construct scatter xy plot. The y data is in column E and remains constant. So i need an input box with 4 options probably and possible IF statement so that...

Hello, I am working on creating an if statement that will allow to a user to choose which column to use (from 3 choices) as X axis while making a plot. Y axis will remain the same. Once user makes the choice, excel should select specified XY range based on choice.Is this possible to create...

Hello! I have data consisted of 18 columns. From these 18 columns I need to produce 9 graphs. However, i dont need to use entire columns for those,only last non empty cells. For instance, i need to take a value from last nonempty cell from a column A and B and use those two points to construct...

Hello, I am working to create xy scatter line graph using two data columns. Since data ranges change occasionally, i need to plot up to last non empty cells. Any advice how to approach this? Also, is there way to create a message box that will ask for a chart title? Im am very new to VBA,so dont...

Hello, I have a complex but simple request for help. I have some data I wish to populate onto a graph which has limited axis of: X axis = -5 to 5 Y axis =-5 to 85 (Please see attached image as an example) I wish to plot 2 series of co-ordinates onto the graph, with joint line. In total...

Hello, I have a set of data from a real time piece of equipment sampled every 15 seconds. To go along with this I calculate various averages, rolling averages, rates of changes between each sample etc. On of the fields I calculate is an average value by the minute. I.e., I have 4 15 second...

I have large amounts of data and would like to cut time down by not having to sift through it manually. Essentially, my the data in interest involves temperature and flow rate. I would like to be able to write a macro to create line graphs. But I want the macro to be able to sort through the...

I have a interactive userform where users can select any number of 15 sets of data and then plot them (x axis is time and is common to all data sets). The data sets are picked by a "yes", "no" combobox before clicking the "Load" command button. How do I get the legend to plot only those...

Hi, I saw this visualization in an Excel file. Trying to plot the element inside the red circle. Do you know how can I plot that? Thanks

The 2016 Box plot graph allows user to show "Inner Points". Has anyone figured out if VBA can check/uncheck this option? No code gets generated with the recorder. Thanks for time and help, -Erock

Hi I've been searching around for a while but couldn't see anything so was hoping to get some help with my problem. I have the following code: Sub test() 'x-axis is time Dim x_axis As Range 'y-axis is other variable Dim y_axis As Range ''To find a column header based on value of A1, when...

Hi, I am trying to plot a Mandelbrot using "gdi32" library function SetPixel after setting 1DC = GetWindowDC(0) Seems to work initially but the Excel window seems to reset/refresh halfway through the plot and either stops plotting or the completed portion of the plot disappears completely. I...

Hello, I have some data and I can create a graph of it. How can I find the instantaneous rate of change (derivative) and plot it? Thanks!

Morning all, I'm playing around with the Map graphing abilities of Excel within my Office365 subscription. I've managed to get it to plot some data for major European countries but not for towns local to my area in Cumbria, UK. Do I need an add-on? Anyway. An example of the (made up) data I'm...

Hello guys, I have data from A2 to A14 in an Excel sheet, for which a linear graph can be displayed next to the data. I wish to plot the same graph but while I have the data ONLY in A2, which changes subsequently (and there is no data anywhere else in the worksheet). That is, as soon as the...

Evening, I have a question for you guys and girls. I am working on a chart that looks like this: https://s7.postimg.org/puskz7m5n/Untitled.png Now my question is: Can the chart plot background be split into a 3 colors depending on their value? I have 3 different criteria 0 - 25000 -...

Hi, I have plotted a 2 x 2 according to the instructions here: How to Create a Static Four Quadrant - Matrix Model in an Excel Chart | Critical to Success ...but I'm encountering some problems: 1) Not all of the labels are showing up for all of the dots on the map - any idea why this is...

Hello! I have coordinate data (specific X and Y value) that I am trying to plot as a scatterplot. What I am plotting is coordinates for a location for every trial in an experiment, so it would look like this: <tbody> Trial X Y 1 504 340 2 507 338 3 518 335 4 527 333 5 539 331 6...

Hi guys, I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph. How do I plot every 7th row of data instead? Below is a small look at what my columns look like (and the rows would be filled in of course)...

Please help! I have to finish this by tomorrow. How do I plot Date/Time vs. Temperature? I have a column of cells formatted like "1/1/2017 12:00:00 AM CST" and the other column simply temperatures "88.98468" I need temp on y-axis and date/time on x-axis. The times are in 5 minute increments...