Search results

Here's a sample workbook. I have to make charts for about 20 different cities, and would prefer automating this process so when the data is changed or added, all the charts don't have to be remade. https://www.dropbox.com/s/aa1aync375anndy/energy_demo.xlsx The end goal is to make a set of 3...

Hi, thanks for the followup but either I am not understanding correctly, or am not explaining very well (both very likely). Here's a hopefully specific example. I have 3 sets of data, each having its own chart (1 chart, 1 series). The 3 total charts will be placed next to each other on a...

Thanks, that is a good trick! If anybody else knows how to do this without having to separate the columns, that would be awesome. I have about 20 sheets of data and don't really want to have to reformat all of it and ensure everything is still linked...

Thanks for the advice- I guess I am trying to preserve the scaling of the y-axis intervals, not the min and max values (the range of values across the data sets is simply too great). Any ideas on how to apply the above idea to the issue of scaling intervals?

Hi all- I am creating bar charts demonstrating the % change in energy consumption for a given sector from year to year. So simplistically, it has years on the bottom with the corresponding % change (3.5%, -2%, etc.) as a bar chart. I would like to make this a little more interesting visually...

Hi- I am working on creating a series of charts highlighting energy use over time. Each chart is for a different sector (residential, commercial, government) and shows energy use over the span of 10 years. By default, Excel has each chart as zoomed in as possible, so any changes in overall...