Dynamic Charting

**k_excel** · 04-21-2008, 10:54 AM

everything i can find on charting the last 12 months dynamically is based on horizontally oriented data. my data is all vertically oriented so i thought that maybe i could just switch around the offset formula given as an example and that it would work, right? wrong. it didn't, maybe i shouldn't even be using that offset formula, who knows? can someone help? i found a really great example to use http://peltiertech.com/Excel/Charts/DynamicLast12.html. but like i said, it's for horizontally oriented data....please help

**oldchippy** · 04-23-2008, 03:51 AM

Hi,

Can't you just right-click on the chart, select Chart type and click Bar?

**robert111** · 04-23-2008, 07:36 AM

old chippy - i think the issue is that the data is in rows and the formulae he has for dynamic charts are based on columns...he may want a line chart

**k_excel** · 04-23-2008, 08:53 AM

I apologize for any confusion, but the direction the data is going is the problem. I am already using a bar chart, if you look at the link from my original post, it shows setting up your actual data in a clean little horizontal table so the offset formula is reading an entire column of data, from top to bottom. In my spreadsheet, the data is going straight across and I can't get the formula to work to even create the chart since my data is vertically oriented. It has something to do with the formula, either I need to modify it, but don't know how, or I need to use a completely different one.