graph series

<tbody> Hi, I've been working on the problem of automating the plotting of line diagrams. But I did not yet manage to solve it yet. I would need multiple charts one for each column (from E to R) using the same column (B) for the X axis. The ultimate...

I want to graph a timeline using excel. However, I don't have the data for every hours The result is this: I don't have the data for 1 AM => 3 AM 6 AM => 9 AM 12 PM & 1 PM 6 PM & 7 PM However, I don't want excel to skip them like that. It's not logical. I want it to insert missing hours and...

Backstory: So I was assigned a project that requires me to graph (chart) values (y-axis) against time (x-axis). For each row there is a "budget", "spent", and "earned" value (easy enough so far). I put together a pretty slick "running total in" pivot chart that was slice-able by any number of...

Hi, I want to make my charts dynamic and can only find explanations of how to do it using data from the chart in column format. i.e. the data goes down from A1:B4. My data goes across the rows. i.e. from A1:D2 How to use defined names to automatically update a chart range in Excel Microsoft...

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

Hello! I am pretty new at using macros, right now I am bit stucked as I am trying to build one that changes a specific series in a series collection and change it to column type if it is in line type and vicerversa. I tried to do it with macro recorder, but it only changes the first series...

hi to all, I am struggling with a dynamic named range formula that will capture 15 weeks of data from the current week back. so, my layout is data laid out by branch (each branch on new row) and by week (week 1 is C1, week 2 is d1, etc). currently reporting the 15 weeks back from Week 31, so my...