- Messages
- 4,347
- Name
- You can call me Sir.
- Edit My Images
- Yes
Morning all,
I've got a problem with a spreadsheet containing a load of graphs. It was always fine in Excel 2003 but gave me some problems when I moved to 2007. I only used 2007 sporadically for this spreadsheet so it never really bothered me but now I've got rid of the old computer I'm plagued by the setup problems in 2007. I hope someone out there can help.
The spreadsheet contains a load of running data for a piece of machinery. The data is input through MS Access and sent across to Excel where a macro is run to import the newest data and clear out the oldest data, it displays the last 256 data entries.
This data is then put into graphs for long term trending of the data.
LT Trend.jpg by Kev "The Prince of Darkroom", on Flickr
At the end of the spreadsheet is a customer report page which contains running data for the previous month. Every month I go in and change the dates on the X-Axis to cover the desired reporting period.
Here's an example of a monthly report graph which has a single Y-Axis. Everything is fine with this as it displays the correct data.
ST Trend Single Y-Axis.jpg by Kev "The Prince of Darkroom", on Flickr
All of my problems stem from graphs with a primary and secondary Y-Axis.
ST Trend Double Y-Axis.jpg by Kev "The Prince of Darkroom", on Flickr
Here you can see the date range I've set for this graph (5/4/2010 - 4/5/2010). The data displayed on the graph goes beyond 4/5/2010 to the 26/5/2010 and my desired date range is bunched up down one end of the graph.
X-Axis Properties.jpg by Kev "The Prince of Darkroom", on Flickr
I'm not sure why I tried it but in desperation I added the "show secondary axis" option to see what it would do.
Secondary X-Axis.jpg by Kev "The Prince of Darkroom", on Flickr
Everything that is on the primary Y-Axis is now displaying the correct date range of values and the date range is displayed across the full width of the primary X-Axis. For some reason the Power Output - MW data has been assigned to the Secondary X-Axis (presumably because it is on the secondary Y-Axis) and I can't get it to follow the primary X-Axis.
I've got a problem with a spreadsheet containing a load of graphs. It was always fine in Excel 2003 but gave me some problems when I moved to 2007. I only used 2007 sporadically for this spreadsheet so it never really bothered me but now I've got rid of the old computer I'm plagued by the setup problems in 2007. I hope someone out there can help.
The spreadsheet contains a load of running data for a piece of machinery. The data is input through MS Access and sent across to Excel where a macro is run to import the newest data and clear out the oldest data, it displays the last 256 data entries.
This data is then put into graphs for long term trending of the data.
LT Trend.jpg by Kev "The Prince of Darkroom", on Flickr
At the end of the spreadsheet is a customer report page which contains running data for the previous month. Every month I go in and change the dates on the X-Axis to cover the desired reporting period.
Here's an example of a monthly report graph which has a single Y-Axis. Everything is fine with this as it displays the correct data.
ST Trend Single Y-Axis.jpg by Kev "The Prince of Darkroom", on Flickr
All of my problems stem from graphs with a primary and secondary Y-Axis.
ST Trend Double Y-Axis.jpg by Kev "The Prince of Darkroom", on Flickr
Here you can see the date range I've set for this graph (5/4/2010 - 4/5/2010). The data displayed on the graph goes beyond 4/5/2010 to the 26/5/2010 and my desired date range is bunched up down one end of the graph.
X-Axis Properties.jpg by Kev "The Prince of Darkroom", on Flickr
I'm not sure why I tried it but in desperation I added the "show secondary axis" option to see what it would do.
Secondary X-Axis.jpg by Kev "The Prince of Darkroom", on Flickr
Everything that is on the primary Y-Axis is now displaying the correct date range of values and the date range is displayed across the full width of the primary X-Axis. For some reason the Power Output - MW data has been assigned to the Secondary X-Axis (presumably because it is on the secondary Y-Axis) and I can't get it to follow the primary X-Axis.
